I have a formula that disappears after the calculation has performed and then the cell remains as the value. Have I messed something up or why is the cell retaining the value and not the formula? Here is what I am using "=AA9-VLOOKUP(AA11,AD8:AF19,3,FALSE)". Nothing appears wrong to me. . .