vlookup in a multiple sheet file

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
 
L

L. Howard Kittle

MICMERG said:
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
Click to expand...
 
L

L. Howard Kittle

Hi Micmerg,

I have a glorious vlookup that does that, it is a Peo Sjoblom solution.
There is no way I could explain it on the news group. Peo sent me an e-mail
detailing how it works and I can only follow a portion of it. However, it
works perfectly!

I can send you what Peo sent me and add some instructions and I think you
will be pleased. Contact me at the below, and perhaps Peo will respond too.

[email protected]

Regards,
Howard
 
Top