Prev: Help writing a formula
Next: Referring to a portion of a column
From: Jacob Skaria on 27 May 2010 17:13
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.-
 | 
Pages: 1
Prev: Help writing a formula
Next: Referring to a portion of a column