Can I use ISERROR with VLOOKUP function?
 

Prabha,

Take a look at the syntax of your ISNA function.
The previous post answered to your question already.

You should lose the ="" after the ISNA parenthesis.

The syntax for ISNA is (as Frank already noted):
IF ( ISNA ( formula ), "", formula ) , and not: IF ( ISNA (formula )
"", "", formula)

I believe that's the way all IS functions work (ISERROR etc.).

This could also have been resolved by using Excel's help.

Regards,
Ale

--
Alex Hatzisava
-----------------------------------------------------------------------
Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26164

Can I use ISERROR with VLOOKUP function?
 

Dear Frank and Alex,
Very many thanks for your advise. It works perfect!.
Shouldn't have missed that with my big fat glasses on!!
Best wishes
Prabha

"Alex Hatzisavas" wrote:


Prabha,

Take a look at the syntax of your ISNA function.
The previous post answered to your question already.

You should lose the ="" after the ISNA parenthesis.

The syntax for ISNA is (as Frank already noted):
IF ( ISNA ( formula ), "", formula ) , and not: IF ( ISNA (formula ) =
"", "", formula)

I believe that's the way all IS functions work (ISERROR etc.).

This could also have been resolved by using Excel's help.

Regards,
Alex


--
Alex Hatzisavas
------------------------------------------------------------------------
Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...o&userid=14559
View this thread: http://www.excelforum.com/showthread...hreadid=261644