I am trying to query a sheet called DataImportTable using INDEX MATCH combo, the only challenge I have is that is I'm looking to match multiple criteria, however, I need to get a specific label in this row match and this label can be in one of any 3 columns I through K.
The criteria I need to match are:
"Diamond" in A:A
"Next" in G:G
"TeamA" in either column I:I or could be in J:J
This DataImportTable will have a query and updated daily via copy and paste.
Here is the formula I'm trying, but isn't producing the results I need: