how to get excel column index by searching with cell text?
excel
Solution
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).
Problem
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).