Look for vertical value then find max value in row and return row header

Dear Forum,

I am having problems with an Index-Match formula. I want to find the value on column BP in column A and when it finds it, I want to look within the specific row for the maximum value for that row, which should be equal to the value on column BO. When these two values are found I want to return the column header of the specified location. I appreciate if you help me pinpoint the problems in the formula I am using, as I don't completely get what I'm doing wrong or missing.

Here is the formula: =IFERROR(INDEX($B$2:$BN$919,ROW(),MATCH(MAX($B:$BN),($B$2:$BN$919=BO3)*($B$2:$BN$919=BP3),0)),"")
And you can look at some examples of the data and the actual output I would like to get in the attached file.

Thanks a lot,
Ale

Try this one

Formula:

Please Login or Register  to view this content.

The MAX function doesn't work with arrays in the same way that some other functions do, you need to isolate the relevant row or column first.