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
Highlighted
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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies