lookup value - true/false

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?

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

HTH
Regards,
Howard

"Peter" <[email protected]> wrote in message
news:[email protected]...
> 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?

woops.

Change b500 to c500

Regards,
Howard

"L. Howard Kittle" <[email protected]> wrote in message
news:[email protected]...
> if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))
>
> HTH
> Regards,
> Howard
>
> "Peter" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>
>

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

"L. Howard Kittle" wrote:

> if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))
>
> HTH
> Regards,
> Howard
>
> "Peter" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>