Forum Discussion
What am I doing wrong?
Let's see if we can break down the formula:
=IF($A$4=HELPER!$B$4='CCM Helper'!$C$4, this conditional clause already is problematic in that it compares three values, A with B with C; was that with the original?
IF(HELPER!B6, in this next, nested conditional, there is no comparison
XLOOKUP(CCMTotalsSP[@[Pod_2]], so I'm going to stop analyzing.
CCMTotalsSP[Metric],
CCMTotalsSP[Pod_2]),
IF($A$16=HELPER!$B$16,
XLOOKUP(C3,LMCCMTotalsSP[Metric],
LMCCMTotalsSP[Pod_2]),"")))
Is it possible that the original formula--which, I'm presuming, did work--is still available to view? Is it possible that it was an IFS function rather than an IF function?
mathetes The original formula was this
=IF(TODAY()=HELPER!$B$4,D4,IF($A$4=HELPER!$B$6,XLOOKUP(C3,CCMTotalsSP[Metric],CCMTotalsSP[Pod_5]),IF($A$4=HELPER!$B$16,XLOOKUP(C3,LMCCMTotalsSP[Metric],LMCCMTotalsSP[Pod_5]),"")))
- But it doesn't work when I changes the date from july to august.
Is that change of date, from July to August, what's captured in cell $B$4 of HELPER! ? If not there, where is that change of date (what cell)?
How exactly are you changing the date? Specifically what are you doing? Are you using Excel date conventions OR might it be possible that you're entering the August date as a text?
Is it possible, in other words, that it's not the formula that's at fault, but rather the way you're entering the new date? [It's a question I have to ask, because that's a very possible cause of the "formula not working"]- With the change of date I get an #value error, In cell $B$4 the date 8/1/2022 is captured. I am changing the month by typing in August 2022 as text. I think it maybe the way I am adding in the date.