Vlookup referencing more than one worksheet
 

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!

Vlookup referencing more than one worksheet
 

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!

Vlookup referencing more than one worksheet
 

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!