vlookup in a multiple sheet file

  • Thread starter Thread starter MICMERG
  • Start date Start date
M

MICMERG

Hi,

I am trying to use the vlookup function to search for data in another file
that has multiple sheets (25). The worksheets all have different names (
not just 1 to 25).

The data I am looking for is all set up with the same columns on each page
so I can look in column F on each page.

So, how can I vlookup on 25 pages at once rather than using 25 different
vlookups.

Thanks in advance
 
Back
Top