Search Text of Cell in a range and return the contents

**shanipk82** · 11-26-2010, 12:05 PM

Hi,

I have a worksheet, with Column A containing some keywords and column b containing domain names, I want to be able to search a keyword in the column of domain names, and if the domain name is found, return the keyword itself in the next column.

A sample sheet is attached herewith.

Regards,

Zeeshan

**Ron Coderre** · 11-26-2010, 12:40 PM

Using your posted workbook...try this ARRAY FORMULA, which is completed by holding down CTRL+SHIFT+ENTER (instead of just ENTER):

Please Login or Register  to view this content.

Copy C2 and paste it into C3 and down as far as you need.

Is that something you can work with?

**shanipk82** · 11-26-2010, 01:32 PM

Originally Posted by Ron Coderre

Using your posted workbook...try this ARRAY FORMULA, which is completed by holding down CTRL+SHIFT+ENTER (instead of just ENTER):

Please Login or Register  to view this content.

Copy C2 and paste it into C3 and down as far as you need.

Is that something you can work with?

Thanks Ron.

Its working perfectly. Thanks a bunch.

How do I change the thread prefix to SOLVED?

Zeeshan

**shanipk82** · 11-26-2010, 01:34 PM

I got it.

Thank you.

Search Text of Cell in a range and return the contents

LinkBack

Thread Tools

Rate This Thread

Display

Search Text of Cell in a range and return the contents

Re: Search Text of Cell in a range and return the contents

Re: Search Text of Cell in a range and return the contents

Re: Search Text of Cell in a range and return the contents

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions