ISNA and ISERROR functions
 

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

--
Jacob (MVP - Excel)


"Emece" wrote:

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