dealing with #N/A

[Trebor777]

Hi

I get #N/A from a Vlookup function. I know why, it's because i use the FALSE arguement as part of Vlookup, and there is no matching entry in the lookup table. this is expected, not the problem.

The recommended solution online is to use a combination of IF and ISNA which I understand. The resulting formula is very messy, requiring the Vlookup formula to be repeated within the IF formula.

This is not a problem, but does anyone have a more elegant way of doing it ? What I want is to replace #N/A with a blank, ie ""

I have not experimented.

Any lateral thinkers out there ?

Deep respect

KK

[Jonmo1]

The normal way with IF and ISNA is like this

=IF(ISNA(VLOOKUP()),"",VLOOKUP())

A more 'elegant' way is with IFERROR, assuming you have XL2007+

=IFERROR(VLOOKUP(),"")

[Trebor777]

Wonderful, mega-thanks. KK

[Jonmo1]

You're welcome.