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
 
=if(b1="",0,vlookup(b1,sheet1!$a$1:$b$500,2))

looks like it should work.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

removing #na from a sheet 7
replacing a #na 2
problems getting this macro to work 23
#NA 3
NA -Errors to show 0 4
Cells shows #NA 1
creating nested formulas from drop down box 5
#NA error on a INDEX formular 5

Back
Top