Return of cell reference

**Saturn** · 06-12-2010, 05:31 PM

How could I have the cell reference to a cell which contain a particular text.

Example:
In a worksheet I have a cell containing the text February.
How can I an easy way find the cell reference which contain February?
Any solutions ?

**opsman** · 06-12-2010, 05:58 PM

=IF(ISNUMBER(SEARCH("February",B8)),1,"")

Ignoring the cell reference B8 which would be whatever cell you wish to be searched, this would return a number 1 if true and "" if false. The true and false values can be altered as per the IF rules.

**Saturn** · 06-12-2010, 06:19 PM

Thanks opsman but this solution return the cell reference.
Lets say February is a text string in cell A2, I want the result to be A2.
How do I do that ?

**shg** · 06-12-2010, 06:33 PM

If you're looking in col A, then

=ADDRESS(MATCH("February", A:A, 0), 1, 4)

**martindwilson** · 06-12-2010, 07:32 PM

if its only one word per cell
then you could set up something like this

**Saturn** · 06-13-2010, 03:44 AM

Hello martindwilson
Yes you are close to what I need. It's about one word in one cell and the reference cell consists also of one word. I want to write that word, somewhere else in the worksheet and have the cell reference where I find that word. I will look into your proposal.
Saturn

PS Tanks also to shg