Index Match Formula

[ZetteS]

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

[xor]

What about a the following adjustment of your own formula in cell G2

=INDEX(('ABP HPL Function'!$C$3:$O$5,'ABP HPL Function'!$Q$3:$AC$5,'ABP HPL Function'!$AE$3:$AQ$5,'ABP HPL Function'!$AS$3:$BE$5,'ABP HPL Function'!$BG$3:$BS$5,'ABP HPL Function'!$BU$3:$CG$5),MATCH(B3;'ABP HPL Function'!$B$3:$B$5,0),MATCH($B$2,'ABP HPL Function'!$C$2:$O$2;0),IF(G$1="Tot_Subs",1,IF(G$1= "Fct Sales",2,IF(G$1="Fct Marketing",3,IF(G$1="fct Finance/Controllership",4,IF(G$1="Fct Human Resources",5,6))))))-F3

(I use semicolon as argument separator, but I hope I have substituted correctly by commas).

[ZetteS]

Hi xor,

It worked even without changing the comma to semi colon as argument separator.
It was a piece of cake for you.
Thanks so much for your help.
Appreciate it much.

Regards,
ZetteS

[xor]

you're welcome.