index match not giving correct result

rservice0320 

Based on the arrangement of your data and the extra argument added to your INDEX, I'm guessing you were trying to use the 'reference' arrangement of INDEX.  It's not commonly used but a solution would look like this (note the parenthesis enclosing the 3 ranges in the first argument):

=INDEX(
    ($D$10:$I$11, $D$14:$I$15, $D$18:$I$19),
    XMATCH($A5, $C$10:$C$11),
    XMATCH(D$4, $D$9:$I$9),
    XMATCH($B5, {"ABC", "DEF", "GHI"})
)

rservice0320 

=INDEX($D$10:$I$19,MATCH(1,($B$10:$B$19=$B5)*($C$10:$C$19=$A5),0),MATCH(D$4,$D$9:$I$9,0))

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.