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

Lookup Formula 4
Function or Sub to help with text string 5
Copy text into blank rows 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
If and LOOKUP - results in multiple columns 6
Loop Through Text and Test for Scenarios Q 31
How do I split a cell into text and number 3
Increment a number based on four adjoing cells 2

Top