Paul Petillion

Important: -> PowerVLookup only works in Excel sheets with data beginning in the first cell. -> The first line must contain the columns headers. -> You need at least 2 sheets of data in order to use PowerVLookup efficiently. (This doesn't necessarily has to be in one workbook) -> It is good to know that the worksheet in wich the results will be stored is the ActiveSheet, the one currently selected. Installation: -> How to install an Excel Add-in : https://support.office.com/en-us/article/View-manage-and-install-add-ins-in-Office-programs-16278816-1948-4028-91E5-76DCA5380F8D...

This little program is born due to an excessive use of the famous Excel formula "vlookup" and the other less known combination "index/match". I hope that those who know either one of them will get the hang of it right away. Important: -> PowerVLookup only works in Excel sheets with data beginning in the first cell. -> The first line must contain the columns headers. -> You need at least 2 sheets of data in order to use PowerVLookup efficiently. (This doesn't necessarily has to be in one workbook)...

This little program is born due to an excessive use of the famous Excel formula "vlookup" and the other less known combination "index/match". I hope that those who know either one of them will get the hang of it right away. Important: -> PowerVLookup only works in Excel sheets with data beginning in the first cell. -> The first line must contain the columns headers. -> You need at least 2 sheets of data in order to use PowerVLookup efficiently. (This doesn't necessarily has to be in one workbook)...