This formula will return the row number where the value "Bob" appears. Say the value happens to be in $A$10, the formula would return: 10
I would like a formula to do a similar thing, except give me the column. For example, if I search for "Bob" in A:F, I would like to know what column it is in. I thought of something like this:
Where the address, B14, is found with a lookup, index/match, etc.