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

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


---
Message posted from http://www.ExcelForum.com/

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

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

HTH
Frank

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

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

Hi Ian

Try
=IF(ISERROR(yourformula),0,yourformula))

--
Regards
Roger Govier
"ian123 " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/