Using vlookup on two worksheets

[Steven Robilard]

Right now I am using vlookup To lookup a name in one worksheet. I
would like to look for that name in two different worksheets.
Specifically to look for a matching name in the first worsheet and if
you don't find it look in the second worksheet.

Here is the function I am using now. I suspect I will have to use
nested if functions but nothing is working right.


=IF(C4500="","",VLOOKUP(C4500,WOOKSHEET1!A:E,3,FALSE))


Thank you,

Steve

 

[JulieD]

Hi Steven

something along the lines of
=IF(C4500="","",IF(ISNA(VLOOKUP(C4500,WORKSHEET1!A:E,3,0)),VLOOKUP(C4500,WORKSHEET2!A:E,3,0),VLOOKUP(C4500,WORKSHEET1!A:E,3,0)))

Cheers
JulieD

 

[Peo Sjoblom]

=IF(C4500="","",IF(ISNA(VLOOKUP1),"",VLOOKUP1,IF(ISNA(VLOOKUP(2),"",VLOOKUP2
,and so on

Howevere there is a limit of 7 nested functions so unless you haven't got
more than a few sheets I would recommend that you download Laurent Longre's
Morefunc from here

http://longre.free.fr/english/

then after installing it use a function called THREED as follows

=IF(4500="","",VLOOKUP(C4500,THREED(Sheet1:Sheet30!A1:E1000),3,0))

 

[Steven Robilard]

Thank you Julie. It worked great.

Hi Steven

something along the lines of
=IF(C4500="","",IF(ISNA(VLOOKUP(C4500,WORKSHEET1!A:E,3,0)),VLOOKUP(C4500,WORKSHEET2!A:E,3,0),VLOOKUP(C4500,WORKSHEET1!A:E,3,0)))

Cheers
JulieD

 

[Ola]

Just for fun. This will also work:

=LOOKUPV(C4500,WORKSHEET1!A:E,3,0,LOOKUPV(C4500,WORKSHEET2!A:E,3,0,""))

Just copy this code: http://tinyurl.com/6o95h


Ola Sandstrom

 

[JulieD]

you're welcome and thanks for the feedback

Thank you Julie. It worked great.