Forum Discussion
Need to force recalculation.
Excel Online I am using the following formula in a 200 cell column: =IF(B3>=1,Vlookup(B3,Budget!$A$5:Budget!$C$140,3,True),"") The formula fails to work when I change the value of B3 (or Bx) but w...
Might help if you posted a spreadsheet showing the problem. The Vlookup you have posted is searching Column A5:A140 for the value in cell B3, and returning the corresponding value in Column C. Is this what you are trying to do?
Geoff1951 That is exactly what I'm trying to do. I seemed to have resolved the problem but I still don't understand why. The lookup column contains a list of account numbers starting with 1.00 in cell A3 and ending with 10.90 in A140. I enter a number in that range in cell B3 (formula in C3 to C199) and it does nothing. Nada... no error message. But, if I copy and paste the formula from any of the following cells it works immediately. If I clear B3 and enter another number it does not work again.... until I copy and past the formula.
Strange...... I changed the first value of the lookup column to 0.00 and now it works.
