Keep getting #NA

[roxiemayfield]

Hi,

I have the following formula that I am having trouble with. If the lookup is
blank I would like the value to be 0. It keeps coming back #NA. What do I do
now?

Thank you for your help.

=VLOOKUP($B13,pmp3w1,3,FALSE)

 

[Niek Otten]

Is pmp3w1 a defined name?
Or did you mean =VLOOKUP($B13,"pmp3w1",3,FALSE)

You can easily substitute #NA with zero, but you should test the correctness of your formula first.

To substitute:
=IF(ISNA(YourFormula),0,YourFormula)
But are you sure? Isn't something wrong with your formula(s)? Why should you take the trouble to develop a formula which doesn't
yield any meaningful result?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I have the following formula that I am having trouble with. If the lookup is
| blank I would like the value to be 0. It keeps coming back #NA. What do I do
| now?
|
| Thank you for your help.
|
| =VLOOKUP($B13,pmp3w1,3,FALSE)

 

[T. Valko]

One way:

=IF(ISNA(VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13,pmp3w1,3,0))

 

[roxiemayfield]

Thank you so much. Works great!

One way:

=IF(ISNA(VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13,pmp3w1,3,0))

 

[T. Valko]

You're welcome. Thanks for the feedback!