cell to show 0 instead of #NA

  • Thread starter Thread starter ditchy
  • Start date Start date
D

ditchy

Hi there excellers
I am using this formula and I need it to show a 0 when there is
nothing in colunm 2, "instead of the #NA" any help appreciated

=VLOOKUP(B1,Sheet1!$A$1:$B$500,2)
regards
Ditchy
 
ditchy

=if(iserror(VLOOKUP(B1,Sheet1!$A$1:$B$500,2), 0,
VLOOKUP(B1,Sheet1!$A$1:$B$500,2))

Just watch the word wrap. I am not sure if it will show properly. But just
piece it together if required.

Regards,
Kevin
 
Hi there excellers
I am using this formula and I need it to show a 0 when there is
nothing in colunm 2, "instead of the #NA" any help appreciated

=VLOOKUP(B1,Sheet1!$A$1:$B$500,2)
regards
Ditchy
Click to expand...

Thank you everyone for your help, you have solved my problem
regards Ditchy
 
Back
Top