Marie -

Try something like this:

=IF(ISNA(<lookup formula),<value to return if N/A,<lookup formula)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Marie Bayes" wrote in message
...
Hi Super clever coders
I would love to have some VB code that I could put into a spreadsheet (or
another clever way to do this) that will return a 0 whenever a VLOOKUP
formula returns a vaue of #N/A. I use VLOOPUP to return values into a
column
which is then totalled using sum or subtotal, but these formulas won't
work
because of the #N/As returned.
Any help woul dbe much appreceiated.