how to get excel column index by searching with cell text?

Question

I have a excel file which has header row and many columns. In row 1, column 10 i have cell value as 'Request'. i need to get this cell index by searching with the value "Request". Is there any way without iterating through columns (without using for loop).

Answer 1

Sample: You are looking in range C2:J2 and H2 has "Request":

 =MATCH("Request"; C2:J2; 0)

will return 6 (column H is the 6th column counting from column C).