Forum Discussion
Combining If and Lookup Functions calculating some cells but not all
Hello, I am having an odd issue with Excel that I cannot seem to find the answer to by searching Google. I have a function that has several if functions, index/match, and lookup functions. The f...
For me to even begin to help, I'd need an excel file with that in it. I cannot begin to disect that in text format.
But before you do that, if you put your data in an Excel table and made sure the column(s) all had 100% consistent formulas, that would go a long way to resolving this I suspect.
Attached is an example of the sheet. Column P is where I am having the issues. As a you scroll down you will see that numbers repeat where it should be either +1 of the previous number or 1 for a new week.
If you click on one of the cells that doubled up the previous number it will update to the correct number.