Forum Discussion
Derek1974
Jan 05, 2020Copper Contributor
One particular excel cell formula not auto-calculating
Hi all, First time on the community, so both excited and a bit nervous that I am putting this in the right way / place. Anyway, I have done a search for this question before, but I am not able t...
mathetes
Jan 05, 2020Silver Contributor
If Alan's suggestion didn't resolve your situation, it would help if you could upload a copy of your actual spreadsheet so we could diagnose on the actual "patient"
In general, no matter how good your description might be, a sample (devoid of private information) of the actual spreadsheet goes a long way toward getting a meaningful answer. (Besides, I'm curious how a LOOKUP formula is being used in this context: are you using the comparison of the most recent day's weight with, say, weight a week prior, to come up with words of encouragement or challenge? That could be a fun way to incorporate that.... so, as I said, I'm curious.)
Welcome to the Excel community.