Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |