Index match with multiple columns/rows

Hi, I need to return a value after matching it by looking at several columns.

I'm suspecting some combination of index match with an array, sumproduct would do the trick. But haven't been able to get it to work

Please see attached workbook.

Thanks!

@Dlinen,
It is against forum rules to post a new query in an existing thread: please start your own thread where you may wish to reference this thread.

Row value

=INDEX($A$1:$A$4,SUMPRODUCT(($B$1:$H$4=$C$7)*(ROW($A$1:$A$4))))

Column value

=INDEX($A$1:$H$1,SUMPRODUCT(($A$1:$H$4=C7)*(COLUMN($A$1:$H$1))))

@JohnTopley,

Oops, sorry... I will remove my post as I figured it out myself.

Cheers,

Another option with the function AGGREGATE.

Originally Posted by Czeslaw

Another option with the function AGGREGATE.

Thanks! This works!

I could get the index sumproduct to work with the dummy data set but no not with the real one for some weird reason. But this works.