I'm having trouble making an INDEX MATCH function that can look for either phrase in the MATCH value for column headings, not both, either or. This is the formula.

=IF(A10=0,"",INDEX('PMI Gun Data "Paste Here"'!$A$1:$BZ$1000,MATCH(A10,'PMI Gun Data "Paste Here"'!$A:$A,0),MATCH("Alloy1",'PMI Gun Data "Paste Here"'!$1:$1,0)))

I want to add "Match #1" to "Alloy1" in the second MATCH function and have it search for one or the other.