vlookup in a multiple sheet file
 

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

vlookup in a multiple sheet file
 

"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

vlookup in a multiple sheet file
 

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

vlookup in a multiple sheet file
 

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

vlookup in a multiple sheet file
 

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

vlookup in a multiple sheet file
 

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