lookup value - true/false

[Guest]

A1= value to look for in B1:B500
if it finds A1 in B1:B500 I want it to return C1.
I can use a VLookup ok, except when doesn't find A1 it returns a #N/A.
I've tried a IF statement around the VLookup, but still runs into the #N/A
issue.
Any suggestions?

 

[L. Howard Kittle]

if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))

HTH
Regards,
Howard

 

[L. Howard Kittle]

woops.

Change b500 to c500

Regards,
Howard

if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))

HTH
Regards,
Howard

 

[Guest]

Ok, that makes some sense, but for some reason it reverses my problem. It
blanks the ones that it can't find (which is good), but gives me a REF on the
ones it does find...Hmm

Whoops! Just needed to customize it a little more so the value if true was a
cell reference...
THANKS!

Peter