Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP ERROR
I started out with =VLOOKUP(F12,CSSP!A10:F2000,4,FALSE)
the output returns #NA if there is nothing found The following statement works great if there is an error. =IF(ISERROR(VLOOKUP(F12,CSSP!A10:F2008,4,FALSE))," 0.00") The problem I am having is if there is actually a good value returned I get the following value in the cell "FALSE" I am doing some calculations on this cell after a value is returned Can anyone help me with this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Error | Excel Worksheet Functions | |||
Vlookup & Lookup function error | Excel Worksheet Functions | |||
Vlookup Syntax Error | New Users to Excel | |||
Vlookup #N/A error due to formatting | Excel Worksheet Functions | |||
#N/A error with VLOOKUP | Excel Discussion (Misc queries) |