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,FAL SE))


Thank you,

Steve

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

"Steven Robilard" wrote in message
...
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,FAL SE))


Thank you,

Steve

=IF(C4500="","",IF(ISNA(VLOOKUP1),"",VLOOKUP1,IF(I SNA(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))

--

Regards,

Peo Sjoblom



"Steven Robilard" wrote in message
...
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,FAL SE))


Thank you,

Steve

Thank you Julie. It worked great.


On Fri, 11 Feb 2005 23:34:34 +0800, "JulieD"
wrote:

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),VLOOKU P(C4500,WORKSHEET1!A:E,3,0)))

Cheers
JulieD

"Steven Robilard" wrote in message
...
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,FAL SE))


Thank you,

Steve

Just for fun. This will also work:

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

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


Ola Sandstrom

you're welcome and thanks for the feedback

"Steven Robilard" wrote in message
...
Thank you Julie. It worked great.


On Fri, 11 Feb 2005 23:34:34 +0800, "JulieD"
wrote:

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),VLOOK UP(C4500,WORKSHEET1!A:E,3,0)))

Cheers
JulieD

"Steven Robilard" wrote in message
...
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,FAL SE))


Thank you,

Steve