One way:

=IF(COUNTIF(B!A1:A10,A1)+COUNTIF('C'!A1:A10,A1),VL OOKUP(A1,IF(COUNTIF(B!A1:A10,A1),B!A1:B10,'C'!A1:B 10),2,0),"Not
Listed")

--
Biff
Microsoft Excel MVP


"Kris W" <Kris wrote in message
...
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!