Hi!

It can be done but it all depends.....

What exactly do you want to do? Lookup a value in sheet1, if not found then
lookup on sheet2, if not found lookup on sheet3?

Need more detail (and be explicit in your detail). Range locations, type of
data(text, numeric), sheet names. This type of detailed info eliminates
replies like:

"It can be done but it all depends....."

"What exactly do you want to do?"

<g

Biff

"Nadia" wrote in message
...
I need to be able to do a vlookup to extract data that can be in 3
different
lists on 3 sheets... is this possible? BTW I cannot combine the data into
one
list.
cheers
Nadia

the reference verson of the index function can look in non adajacent
ranges,not sure if that extends to seperate worksheets tho
--
paul
remove nospam for email addy!



"Biff" wrote:

Hi!

It can be done but it all depends.....

What exactly do you want to do? Lookup a value in sheet1, if not found then
lookup on sheet2, if not found lookup on sheet3?

Need more detail (and be explicit in your detail). Range locations, type of
data(text, numeric), sheet names. This type of detailed info eliminates
replies like:

"It can be done but it all depends....."

"What exactly do you want to do?"

<g

Biff

"Nadia" wrote in message
...
I need to be able to do a vlookup to extract data that can be in 3
different
lists on 3 sheets... is this possible? BTW I cannot combine the data into
one
list.
cheers
Nadia