vlookup in a multiple sheet file

[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. Howard Kittle]

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. 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.

(e-mail address removed)

Regards,
Howard

 

[L. Howard Kittle]

Hummm...
Two replys, ???
Not sure what happend there, sorry.

Howard

 

[MICMERG]

Hi,

tryed to send you an email but came back as unknown address

 

[L. Howard Kittle]

Sorry, I had a typo.

(e-mail address removed)

Regards,
Howard