Using vlookup on two worksheets

S

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
 
J

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
 
P

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))
 
S

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
Click to expand...
 
Top