INDEX MATCH alternative similar to COUNTIFS, but pastes values, not counts -> huge matrix

Hello Folks,

I have a matrix that looks like this:


NAME CLASSNAME1 CLASSNAME2 CLASSNAME3 CLASSNAME4 CLASSNAME5 ... --> many columns
NAME1
NAME2 These cells are supposed to contain GRADES retreived from a separate dataset
NAME3
...no duplicates
in this column

REFERENCE DATA COMES FROM THREE COLUMNS: 1. NAME, 2. CLASSNAME, 3. GRADE
There are many thousands of NAMES, hundreds of CLASSNAMES, and thousands of GRADES. NAME1, NAME2...repeats for multiple classes, but each possible CLASSNAME for a given NAME can have only one GRADE

GOAL: TO PASTE A UNIQUE GRADE INTO EACH CELL WHERE: NAME1=CLASSNAME1... GRADE is positioned directly to the right of NAME and CLASSNAME in the reference dataset

NOTE: INDEX & MATCH only retreives the first occurrence of a TRUE event in each row, thus it does not work. However, COUNTIFS WORKS, but does not place GRADE in the cell, only the count.

I HAVE TRIED EVERYTHING! Please help if you can. Thank you sooo much!

SOLVED! ‘=IFERROR(INDEX(hh!$C$2:$C$3843,MATCH($A2&"|"&B$1,INDEX(hh!$A$2:$A$3843&"|"&hh!$B$2:$B$3843,0),0)),"")

Thank you everyone, for your help!