ISNA help

[CJJ]

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]

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]

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