-> 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.
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
-> How to create a new button on the office ribbon:
https://support.office.com/en-us/article/Assign-a-macro-to-a-button-728c83ec-61d0-40bd-b6ba-927f84eb5d2c
For more help ... read the readme file
Last edit: Paul Petillion 2017-08-01