| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Error
I have the following formula with an error. I am trying to get an na to be a
-0- if the lookup is 0. =IF(ISNA((VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13 ,pmp3w1,3,FALSE) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Error
Try
=IF(ISNA(VLOOKUP(B13,pmp3w1,3,0)),0,VLOOKUP(B13,pm p3w1,3,0)) Mike "roxiemayfield" wrote: I have the following formula with an error. I am trying to get an na to be a -0- if the lookup is 0. =IF(ISNA((VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13 ,pmp3w1,3,FALSE) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Error
Thank you so much! That works. "Mike H" wrote: Try =IF(ISNA(VLOOKUP(B13,pmp3w1,3,0)),0,VLOOKUP(B13,pm p3w1,3,0)) Mike "roxiemayfield" wrote: I have the following formula with an error. I am trying to get an na to be a -0- if the lookup is 0. =IF(ISNA((VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13 ,pmp3w1,3,FALSE) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Error
Glad I could help, it was only a parenthesis problem
"roxiemayfield" wrote: Thank you so much! That works. "Mike H" wrote: Try =IF(ISNA(VLOOKUP(B13,pmp3w1,3,0)),0,VLOOKUP(B13,pm p3w1,3,0)) Mike "roxiemayfield" wrote: I have the following formula with an error. I am trying to get an na to be a -0- if the lookup is 0. =IF(ISNA((VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13 ,pmp3w1,3,FALSE) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Error | Excel Discussion (Misc queries) | |||
| Formula Error | New Users to Excel | |||
| Formula Error | New Users to Excel | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
| Formula error... | Excel Discussion (Misc queries) | |||
Hybrid Mode
