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.
|