How can I use a VLOOKUP function to search a multi-page workbook?
I regularily use VLOOKUP but want to create a LOOKUP that will search all
pages of a workbook and return the required data. I am using a distinct
customer number that will only appear once.
|