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.