ISNA and ISERROR functions

  • Thread starter Thread starter Emece
  • Start date Start date
E

Emece

Hi.

I need some samples of ISNA and ISERROR functiones. Is there a web where I
can download samples of them?

Thanks in advance

Regards,
Emece.-
 
Try these formulas

'If the lookupvalues is not found it will return a na() error
=VLOOKUP("something",Sheet2!A:B,2,0)

'returns true if value is not found and false if value is found
=ISNA(VLOOKUP("something",Sheet2!A:B,2,0))

'Handle na() errors using IF()
=IF(ISNA(VLOOKUP("something",Sheet2!A:B,2,0)),"Not found","Found")

Try the same with ISERROR() which will handle other errors too..
Click to expand...
Can you combine ISERROR and ISNA functions? I want to remove blanks
and #NA.
 
Can you combine ISERROR and ISNA functions? I want to remove blanks
and #NA.
Click to expand...

Can you be more specific in what it is you are trying to do?

--

Regards
Roger Govier



__________ Information from ESET Smart Security, version of virus signature database 5226 (20100624) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top