Column Number of a cell with text

H

Hilvert Scheper

Hi All,
I'd be Greatful if someone could answer me this question:

Is there a Formula that gives me the Column Number of the Cell that contains
the Text "ThisText", returning a number 5 in this example:

Example:
Col. A Col. B Col. C Col. D Col. E
"Nothing" "Everything" "Here" "There" "ThisText"

I have tried something like "=COLUMN("ThisText")" but that does not work.
Any help here is Much appreciated!!
Many TYhanks,
Hilvert
 
H

Hilvert Scheper

Hi Don,
Thank You Very much, just the push into the direction I needed.
Thanks again,
Hilvert
 
T

T. Valko

Note that MATCH will return the column number *relative* to the range. If
you want the absolute column number:

=LOOKUP(2,1/(F8:J8="thistext"),COLUMN(F8:J8))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup_surya_siva 2
Column number of last column that returns value ignore formulas 8
if statement, change cell only if true 4
Find largest value in column with 2 criteria 1
Sum Products with VLOOKUP 3
match and extract 4
Trying to match 1 value to multiple columns 10
Find a number in a column then return a value from another cell 2

Top