Hi,
I was trying to work on the index match formula for an overhead review by function spreadsheet and it doesn't work.
The index match formula I used, worked for the total function but not for the specific function.
Tab "CC vs Plan" column D formula worked but not column G. I was expecting Column G should be getting the number from tab "ABP HPL Function" column AA.

Appreciate some help with the index match formula. If there is a better formula to get the number I'm after it will be greatly appreciated.

Thanks,
ZetteS

Attached Files

Overhead Review.zip (1.01 MB, 15 views)