In your if statement you only have the true responce It should answer false
when there is no error.
Try
=IF(ISERROR(VLOOKUP(F12,CSSP!A10:F2008,4,FALSE))," 0.00",VLOOKUP(F12,CSSP!A10:F2008,4,FALSE))

"Mark Adams" wrote:

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.