Hello,
I am trying to find the correct corresponding value on the Baseline forecast sheet for cells C9:C13 on Sheet5. I believe index match is correct, but I am producing and error. The criteria is that cell B9 on Sheet5 should match the value in row 1 on Baseline Forecast. In addition the month and year in cell B6 on sheet five should match Column A on Sheet5. So the correct value for C9 on Sheet5 would be cell B27 ( $5,104,124 ) on the Baseline forecast because it matches the month and year and is the gross revenue. I have the following formulas (both) and they are both producing errors. Your time is always appreciated!!
=INDEX('Baseline Forecast'!B1:O37,MATCH(Sheet5!B9,'Baseline Forecast'!B1:O1,0),MATCH((MONTH(B7)&YEAR(B7)),(MONTH('Baseline Forecast'!A2:A37)&YEAR('Baseline Forecast'!A2:A37)),0),)
=INDEX('Baseline Forecast'!B2:O37,MATCH(1,('Baseline Forecast'!B1:O1=Sheet5!B9)*((MONTH('Baseline Forecast'!A2:A37)&YEAR('Baseline Forecast'!A2:A37))=(MONTH(Sheet5!B7)&YEAR(Sheet5!B7))),0),)
Thanks!
Bookmarks