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