Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html

....then use this formula

=IF(ISNA(VLOOKUP(A1,THREED('B:C'!A1:B10),2,0)),"No t
Listed",VLOOKUP(A1,THREED('B:C'!A1:B10),2,0))



"Kris W" wrote:

Hi

(Excel 2003)

I have a vlookup formula in worksheet A, which looks up worksheet B, but I
need it to look up worksheet C also - how do I do this?

I also need it to say "Not Listed" instead of "#N/A" as it does at the
moment...

Thanks!