Home

Need to force recalculation.

%3CLINGO-SUB%20id%3D%22lingo-sub-550769%22%20slang%3D%22en-US%22%3ENeed%20to%20force%20recalculation.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550769%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20Online%3C%2FP%3E%3CP%3EI%20am%20using%20the%20following%20formula%20in%20a%20200%20cell%20column%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(B3%26gt%3B%3D1%2CVlookup(B3%2CBudget!%24A%245%3ABudget!%24C%24140%2C3%2CTrue)%2C%22%22)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20formula%20fails%20to%20work%20when%20I%20change%20the%20value%20of%20B3%20(or%20Bx)%20but%20will%20work%20if%20I%20simply%20copy%20and%20paste%20the%20formula%20from%20any%20other%20cell%20in%20the%20column%20after%20changing%20the%20value%20of%20the%20column%20B%20Cell.%26nbsp%3B%20I%20have%20tried%20to%20omit%20the%20%22True%22%20and%20I%20have%20tried%20to%20change%20it%20to%20%22False%22%20but%20it%20is%20the%20same.%26nbsp%3B%20Help...%20Please%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-550769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-552254%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20force%20recalculation.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552254%22%20slang%3D%22en-US%22%3EMight%20help%20if%20you%20posted%20a%20spreadsheet%20showing%20the%20problem.%20The%20Vlookup%20you%20have%20posted%20is%20searching%20Column%20A5%3AA140%20for%20the%20value%20in%20cell%20B3%2C%20and%20returning%20the%20corresponding%20value%20in%20Column%20C.%20Is%20this%20what%20you%20are%20trying%20to%20do%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560239%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20force%20recalculation.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338750%22%20target%3D%22_blank%22%3E%40Geoff1951%3C%2FA%3E%26nbsp%3B%20%26nbsp%3B%20That%20is%20exactly%20what%20I'm%20trying%20to%20do.%26nbsp%3B%20%26nbsp%3BI%20seemed%20to%20have%20resolved%20the%20problem%20but%20I%20still%20don't%20understand%20why.%26nbsp%3B%20%26nbsp%3B%20The%20lookup%20column%20contains%20a%20list%20of%20account%20numbers%20starting%20with%201.00%20in%20cell%20A3%20and%20ending%20with%2010.90%20in%20A140.%26nbsp%3B%20%26nbsp%3BI%20enter%20a%20number%20in%20that%20range%20in%20cell%20B3%20(formula%20in%20C3%20to%20C199)%20and%20it%20does%20nothing.%26nbsp%3B%20Nada...%20no%20error%20message.%26nbsp%3B%20But%2C%20if%20I%20copy%20and%20paste%20the%20formula%20from%20any%20of%20the%20following%20cells%20it%20works%20immediately.%26nbsp%3B%20If%20I%20clear%20B3%20and%20enter%20another%20number%20it%20does%20not%20work%20again....%20until%20I%20copy%20and%20past%20the%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3EStrange......%20I%20changed%20the%20first%20value%20of%20the%20lookup%20column%20to%200.00%20and%20now%20it%20works.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Khun_Robert
New Contributor

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 will work if I simply copy and paste the formula from any other cell in the column after changing the value of the column B Cell.  I have tried to omit the "True" and I have tried to change it to "False" but it is the same.  Help... Please

 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies