From: Jacob Skaria on
Try these formulas

'If the lookupvalues is not found it will return a na() error

'returns true if value is not found and false if value is found

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