Hello,

I am trying to perform a vlookup using the correct formula, and applying it
to a large range of cells in a row. Now, when the vlookup finds the correct
match in the array it returns the correct value [yeah :)], but when there is
no matching value it returns #NA, which affects the whole spreadsheet. Is
there any way I can get it to return a zero instead????

Desperately in need of help!!