Vertical search and NULL

A

alpinlands

Hi Gents,
I am doing a vertical search to return some data from a
selected area.
Everything works fine unless the value I am looking for is not present
and therefore the formula returns #N/D, which ruins everything else I
intend to program.
What can I do to NOT see a NULL value (#N/D) but something else
instead?
I could use the IF formulas, but it does not work with "#N/D".

Thanks
 
G

Gary L Brown

???
=If(IsNa(vlookup("A",A:B,2,false)),"Something Else", vlookup("A",A:B,2,false))
The operative part is the Isna() function.
Don't know if this is what you're looking for as I've not seen the "#N/D"
error message before.

HTH,
 
Top