Thread: Can I use ISERROR with VLOOKUP function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Hatzisavas[_2_] Alex Hatzisavas[_2_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote