Forum Discussion
What am I doing wrong?
The formula is
=IF($A$4=HELPER!$B$4='CCM Helper'!$C$4,IF(HELPER!B6,XLOOKUP(CCMTotalsSP[@[Pod_2]],CCMTotalsSP[Metric],CCMTotalsSP[Pod_2]),IF($A$16=HELPER!$B$16,XLOOKUP(C3,LMCCMTotalsSP[Metric],LMCCMTotalsSP[Pod_2]),"")))
The workbook has to be updated daily, the person who owned the file quit the company and left no instructions on month end for this work book. The data that is needed to show is there but since I changed the month to August it won't populate for some reason if though the helper files says its August 2022. I am unable to share the file because it has name and states August 2022, look up the potentially billable number from this cell (C4) in the ccm helper file(the number changes daily). I don't care about adding last months information as a second option since that data is inaccurate.
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.
