Thread: Index Match Formula
View Single Post
 
Old 09-20-2018, 04:25 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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).
Reply With Quote