I am using the if function to put amounts into three catagories (<6000, <30000 and <75000) then I am using the vlookup function to apply a tax formula to these amounts. When using vlookup it brings back a false result because it is looking up the formula, not the result of the if function.
Is there another way to make vlookup look up the result and not the formula, other than pasting special as I need the formulas for future reference.
ok, I have a table of employee salaries in A1. I need to put these salaries into catagories for the taxtable; <6000, <30000 and <75000 in column B1 thus using the formula: =IF(A1<6000,"nil",IF(A1<30000,"30000",IF(A1<75000, "75000")))

I then need to use the vlookup function in C1 to look up the catagory and apply the tax formula: =vlookup(B1,taxtable,2,false)

but the IF function is in B1, not the result.. so when vlookup is looking for "30000" it can't be found because the cell has the IF formula, not the result displayed.

I can't save the formula as text because I need the formual and I can't think of another formula to use