Keep getting #NA
 

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)

Keep getting #NA
 

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

"roxiemayfield" wrote in message
...
| 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)

Keep getting #NA
 

One way:

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

--
Biff
Microsoft Excel MVP


"roxiemayfield" wrote in message
...
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)

Keep getting #NA
 

Thank you so much. Works great!

"T. Valko" wrote:

One way:

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

--
Biff
Microsoft Excel MVP


"roxiemayfield" wrote in message
...
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)

Keep getting #NA
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"roxiemayfield" wrote in message
...
Thank you so much. Works great!

"T. Valko" wrote:

One way:

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

--
Biff
Microsoft Excel MVP


"roxiemayfield" wrote in
message
...
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)