Search for the first cell that contained a specific text

**Dena** · 10-17-2014, 01:29 PM

How can I write a formula that will look for the first row that contains matching data

Example:

The formula will be in X column.

I enter "1234" in E234, I want the formula to look in Column F for the first row that has the same data. So if "1234" is written in F2, F11, F200, etc. I want it to reference (Row 2) F2 and then copy whats in C2 and enter it into X2.

Does that make sense?

**zbor** · 10-17-2014, 01:33 PM

Write in X2:

Formula:

Please Login or Register  to view this content.

**daffodil11** · 10-17-2014, 01:34 PM

=index(c:c,small(if(x:x="1234",row(x:x)),row(a1)))

**Dena** · 10-17-2014, 01:46 PM

Thank you everyone, Zbor, your formula did the trick.

Search for the first cell that contained a specific text

LinkBack

Thread Tools

Rate This Thread

Display

Search for the first cell that contained a specific text

Re: Search for the first cell that contained a specific text

Re: Search for the first cell that contained a specific text

Re: Search for the first cell that contained a specific text

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] To search specific text in a cell that contains text string

[SOLVED] Return specific text if a different text is contained anywhere in a range of cells

[SOLVED] Macro to search for value contained in a cell

[SOLVED] Macro to search rows for specific text within a cell then cut cell to specified location

[SOLVED] How do I search for specific text and sum the cell to the right?

Bookmarks

Bookmarks

Posting Permissions