Text Search and Return Results ?

I might be not thinking the obvious here but quick question. I have a customer who wants to do text searches off a column and return all rows with a keyword that is found. Any suggestions to the most efficient way to do this? Basically I have columns from A-G. The searched column would be G. If the keyword pops up it populates all columns of that row. We are doing an SSRS report for this but also want to see if it can be created in Excel...Any help would be appreciated.

thanks all. I think youve all given me enough info to play around with this. appreciate all of your prompt replies!!! have a great day!

I am not doing something right. If you have a sec can you see if I am doing something incorrectly assuming my ranges are accurate? Thanks.

{=IFERROR(INDEX('OBS RAW'!$A$1:$T$6109,AGGREGATE(15,6,ROW($A$1:$T$6109)/((ISNUMBER(SEARCH(U1,'OBS RAW'!$R$1:$R$6109)))),ROWS(A$1:A1))-(1-1),COLUMN()),"")}

I cant post because of that but looking at your file now and it explains everything. thanks again.

Two questions from the workbook and how I detailed my issue (my bad). Your formula as follows:

=IFERROR(INDEX('OBS RAW'!$A$1:$T$6109,AGGREGATE(15,6,ROW($A$1:$T$6109)/((ISNUMBER(SEARCH(AA1,'OBS RAW'!$R$1:$R$6109)))),ROWS(G$1:G1))-(1-1),COLUMN()),"")

Under Search shouldnt the AA1 be locked down for when we drag the formula? This is where it is doing the word search correct?

Other is my explanation. The field it is searching is a comment cell. Basically we want to type a keyword into AA1 so for instance car, and if that word shows up in the text detail it will populate so it isnt a scenario where there is a category or one term in the column we are looking for rather a paragraph where we want that result to show if any word comes up in it. any help would be appreciated when you have time. thanks.

ok thanks. i will play around with it.

I might have to repost this question because I didnt explain properly. Your approach works perfectly for single words and even partial sections of words but the text format I have isnt working with it.

I really cant. But will give you an example. The cell itself is tagged General and it has paragraphs in it. So something like this. Say we want all cells with the word car in it to display from the below:

The car went down the street and went through a stop sign. It was promptly pulled over by police.

That specific cell would then be populated into the tab with the formulas.

If your data is confidential, use false data but still describe the situation and condition of your original data and the results you want

I created a separate spreadsheet to show what I am looking for. I want to search for keywords in column G text field. If any occurrence of a word shows up, then I want the entire row to display. Then displays every occurrence of that word in the entire dataset same way.

So if the word car is typed into the cell, rows 2 through 4 show up in the tab. I am attaching the sample. Any help thanks.

How is it?

I was offline yesterday. I want to be able to type one or two words in and if those words are found in the cell than return the entire row. The customer is interested in typing a keyword in and then getting all the entries that contain those words. So in the car example, simply typing car to return every entry in G that has that word in itn.

thanks so much. this is perfect. appreciate your help. very nice of you to take time.