| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
