VLOOKUP error in Excel #NA

Question

=VLOOKUP(A5,'vlookup HT'!$A$2:$B$978,2,0)

When I use this above vlookup it works correctly but when there is no data available it shows up as #NA.

Is there a way to get it to show a 0 instead of #NA? I am working with numbers and need to do totals and am unable to. The workaround I have for now is to copy and do a paste special in another worksheet and then replace the #NA with 0.

Answer 1

This will let you difince addiional errors in addition to #na:

=IFNA(VLOOKUP(A5,'vlookup HT'!$A$2:$B$978,2,0), 0)

Answer 2

You could do:

=IFERROR(VLOOKUP(A5,'vlookup HT'!$A$2:$B$978,2,0), 0)