In Google Spreadsheets I have a number of columns that I have given title to in Row 1.
Using a formula, I want to return the column number (i.e. 5, 6, 7, ...) for the column that has a specific title.
GetColumnNumber() function above doesn't actually exist, but it demonstrates what I'm trying to do.
Is there a way to achieve the same result?
I've found this function reference which I've been trying to sift through: