excel formula to search Multiple strings in several columns and return strings

**krratna123** · 08-13-2013, 08:56 AM

I want an Excel Formula for Search multiple String from Multiple Columns and return Values If Found in different columns. For Example I have Data Like:

In Column A : 3 data: A2: URR/THU/MON ,A3: URR/ETC.C ,A4: URL/ETC.V...........

In Column B : 1 data: B2: URL/THR/RTH ......

Lets assume This Much Data I Have. and I wanted to search URL and URR from column A and B. and Need to return Values in Column C. If 2 value found need to return both with sepearte Coma. I cant Use Nested IF because in that only 7 "IF" I can Use. I have totally more than 25 Keywords to search in more than 20 columns.

**XOR LX** · 08-13-2013, 09:02 AM

Hi,

If you could post a sample spreadsheet with a few examples and your desired results in each case, that would be useful.

Regards

**krratna123** · 08-13-2013, 09:34 AM

Expected.jpg

Please check attached Image for Desired Output on provided Input in A and B Column.

**XOR LX** · 08-13-2013, 09:56 AM

Ah, no, I meant an actual spreadsheet.

The reason being that in order to solve such queries, it's far preferable to have an actual Excel sheet in which to test and experiment ones tries. And most Forum Members will not necessarily be willing to spend the time to copy/create a spreadsheet of their own based on information from a picture just in order to be able to do so.

Regards

**krratna123** · 08-13-2013, 11:20 AM

Check Attached XLS. I want a formula to get strings "URRC" or "URLC" or "UPHY" or "Platform" in Module Column from column C to end column. Out put should respective to respective row.

excel formula to search Multiple strings in several columns and return strings

LinkBack

Thread Tools

Rate This Thread

Display

excel formula to search Multiple strings in several columns and return strings

Re: excel formula to search Multiple strings in several columns and return strings

Re: excel formula to search Multiple strings in several columns and return strings

Re: excel formula to search Multiple strings in several columns and return strings

Re: excel formula to search Multiple strings in several columns and return strings

Thread Information

Users Browsing this Thread

Similar Threads

excel formula to search Multiple strings in several columns and return strings in a separa

Formula to search for multiple strings

Question on using SEARCH formula to search for multiple strings in a cell

multiple strings in each colomn cell to be compared and returned with similar strings

-how to use VBA to search strings and return values or cells nearby

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions