Actually, not true. If you use the IFERROR function rather than
IF(ISERROR()), then you can do this:

=IFERROR(VLOOKUP(), 0)

This will return the result of the VLOOKUP if the VLOOKUP is successful but
will return the second parameter (in this case, 0), if the VLOOKUP is
unsuccessful.

This is definitely a more efficient approach than the IF(ISERROR())
construction since the VLOOKUP is performed only once.

-Charles


"Bob Phillips" wrote:

Yes, once to check if the VLOOKUP returns an error, once to get the result
if it doesn't.

--

HTH

RP

"Arla" wrote in message
...
I am sorry if I am being dense; so now that I have added the "iserror"
portion to the formula, do I need to have "vlookup" in two spots rather
than
just once?

"Dave Peterson" wrote:

=if(iserror(vlookup(...)),0,vlookup(....))



Arla wrote:

I am using a VLookup function. I need to find an exact match, but
when there
is no match, I would like to see a zero, rather than #N/A. Can
someone help
me with a different formula to produce similar results as I am getting
with
the VLookup without the #N/A?

--

Dave Peterson