In the meantime and in the event you have Product 2021 or newer try this formula in H3 and copy down.Formula:
=INDEX(FILTER($C$3:$C$11,ISNUMBER(FIND($C$3:$C$11,G3))),1)
I could not follow the information in "Comments". This is the best I could do. I suspect it is not what you expect. In column JFormula:
=INDEX(FILTER($C$3:$C$11,ISNUMBER(FIND($C$3:$C$11,G3))*(E3=$A$3:$A$11)*(F3=$B$3:$B$11)),1)
Bookmarks