Excel Formula: What is the equivalent of =MATCH(), but for multiple columns?

MATCH only works with a single column or row, so you can use a row like 1:1 rather than A:A

=MATCH("Bob",1:1,0)

That will give you a number, so if "Bob" is first found in Z1 you'd get 26.....or do you need something different?

Do you have a larger problem of which this is a part?

Edited in response to comments:

This "array formula" will search for A2 anywhere in Summary!A2:Z1000 and return the column header from the first column where that value is found

=INDEX(Summary!A1:Z1,SMALL(IF(Summary!A2:Z1000=A2,COLUMN(Summary!A2:Z1000)-COLUMN(Summary!A2)+1),1))

formula needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

A hidden column within the lookup range will do it, enabling you to use MATCH to bring back a sub-array - in my case a 1 row x 5 column subsection of the named range _Maturity:

=OFFSET(INDEX(_Maturity,MATCH($B7&$C7,INDEX(_Maturity,0,3),0),0),0,3,1,5)

The _Maturity array is 8 columns wide with a dynamic row length (using OFFSET and COUNTA).

Column 1 holds the value for B, column 2 for C - these are concatenated in hidden column C (hidden) - hence, the column offset of 3 in the second Index function.

Hope this helps.