VLOOKUP

Nenagh · Dec 7, 2006

Hi, wondering if anyone can help.

I am using the vlookup function and i want 0 returned if an exact match can
not be found?

Cheers

T. Valko · Dec 7, 2006

Try this:

=IF(ISNA(VLOOKUP(........)),0,VLOOKUP(........))

Biff

T. Valko · Dec 7, 2006

You're welcome!

Biff

Nenagh said:
Hi

Thanks very much

Worked a treat