Index Match with Criteria - return list

Hi guys here's what I'm trying to do. See Dummy data attached

In Column BH6:BH16, I need the function to look up the value in BG6 and match that with row 4, look up the value in column BI6:BI16 and match the values in row 36, and then return the value in row 5 (i.e., the output). The twist is that some of the values in BI6:BI16 could be the same but the output's should not be repeated.

In this example, the value 103 is repeated three times but each "103" could correspond to one of three different outputs. I've included the actual answers that should be shown in column BJ6:BJ16.

Thank you for the help!

Hi Bo, thanks for always helping.

That worked for all values EXCEPT the ones that repeat. It returned the same output for BH8:BH10 when they should be different outputs.

Yup, worked like a charm. Thank you! I'm finally done with this project and can stop bugging y'all lol.