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

"MICMERG" wrote in message
...
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

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.



Regards,
Howard

MICMERG" wrote in message
...
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

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

Howard

"MICMERG" wrote in message
...
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

Hi,

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

"L. Howard Kittle" wrote:

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.



Regards,
Howard

MICMERG" wrote in message
...
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

Sorry, I had a typo.



Regards,
Howard

"MICMERG" wrote in message
...
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