Hello All:
I am trying to write a vlookup formula using multiple pages in the table array.
I have tried using range names as well as just typing in the ranges.
I am trying to get specific cell data from various pages of a workbook, for example
the data I am looking for could be on anyone of 10 pages of the workbook.
I want to search all 10 pages to find the matching lookup value and then take data from column 2 and insert it on the page where I have written the vlookup formula.
Thank you in advance for your help