Hi

ISERROR is very broad and will trap all errors not just the #NA error
i would suggest using

=IF(ISNA(VLOOKUP(A5;A:A;8;FALSE));0;VLOOKUP
(A5;A:A;8;FALSE))

instead

Cheers
JulieD

wrote in message
...
This works always!

=IF(ISERROR(VLOOKUP(A5;A:A;8;FALSE));0;VLOOKUP
(A5;A:A;8;FALSE))

Mr.G
- Up North

-----Original Message-----
=IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....))


On Mon, 10 Jan 2005 19:19:03 -0800, "Cmatise"
wrote:

When VLOOKUP returns a #N/A How can you get it to
replace #N/A with a 0

.