**Problem**

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

```
=MATCH("Bob",A:A,0)
```

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:

```
=INDEX(1:1,MATCH("Bob",A:F,0))
```

or

```
=CELL("col",B14)
```

Where the address, B14, is found with a lookup, index/match, etc.