I'm getting #N/a but i want 0 or '-'

  • Thread starter Thread starter ian123
  • Start date Start date
I

ian123

Having run a vlookup i am getting the return value of "N/a" wherever a
value is not found.

Is there a way i can get this to read '0' or '-' instead as it effects
later formulae and sum functions.

Many thanks
 
Hi
try the following:
=IF(ISNA(your_vlookup_formula),"-",your_vlookup_formula)

HTH
Frank
 
Back
Top