lookup value - true/false

P

Peter

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

L. Howard Kittle

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

HTH
Regards,
Howard
 
L

L. Howard Kittle

woops.

Change b500 to c500

Regards,
Howard

L. Howard Kittle said:
if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))

HTH
Regards,
Howard
Click to expand...
 
P

Peter

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
 
Top