ISNA and ISERROR functions

[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.-

 

[tylerstjohn]

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..

Can you combine ISERROR and ISNA functions? I want to remove blanks
and #NA.

 

[Roger Govier]

Can you combine ISERROR and ISNA functions? I want to remove blanks

and #NA.

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