My first time to use this site, but looks like Pete_UK could probably help me
out.

I have an array which contains two columns, a text string in the first and
numeric values in the second. My problem is since I want to use 'exact'
match, VLOOKUP returns #na when not found. I need the return value to always
be numeric 0 if not found, rather than the #na, as the cells populated by the
formula are totaled, and =sum does not work with any #na value in the column.

Is there a way of making VLOOKUP do what I need, or some other
function/formula which would work instead.

Thanks,
--
Clay