ISNA help

CJJ · Jul 1, 2003

I have the following function in a cell returning #N/A
=VLOOKUP(A4,february_data,21,FALSE)
I think ican use the ISNA to return a zero but I am struggling to apply.
Can anyone help??
Thanks in advance.

--

This e-mail has been virus checked before transmission by Norton Anti-Virus
2002

Aladin Akyurek · Jul 1, 2003

Oft-used idiom for that is...

=IF(ISNA(VLOOKUP(A4,february_data,21,0)),0,VLOOKUP(A4,february_data,21,0))

A fast alternative is...

=IF(ISNA(SETV(VLOOKUP(A4,february_data,21,0))),0,GETV())

which requires the morefunc.xll add-in from
http://longre.free.fr/english/index.html.

Muhammad Jawad Mirza · Jul 1, 2003

Dear CJJ,
Make some modifications in the formula
=IF(ISNA(VLOOKUP(A4,february_data,21,FALSE)),"",VLOOKUP
(A4,february_data,21,FALSE))

The first portion of ISNA(VLOOKUP()) checks the mathched
value. IF it is not avaiable the empty string will be
placed in the cell otherwise your normal VLOOKUP() will
work.

Thanks for your query.

Muhammad Jawad Mirza

ISNA help

CJJ

Aladin Akyurek

Muhammad Jawad Mirza