Display All results from word list that appear in cell

Hi

I am new to Excel Forum and have posted on http://www.excelforum.com/excel-form...ding-text.html regarding a modified version of what they have done

Please can someone advise as to how to do this query but show all results found rather than just one result

that thread is showing as solved so I didn't know if it would ever be responded to.

Thanks

Samuel

As the below


------------------------------------------------------------------------

Hello Everyone

This formula is a great help to me also however I do have a question

I want the result to be able to show multiple terms from the search terms and index.

for example

Bob's BMW and Ford

Result would be

BMW,Ford

Rather than just Ford

Is this possible?

Any help would be greatly appreciated and beneficial

Thanks

Samuel

You did right in starting your own thread - you should not hijack someone else's thread by asking your own questions there (see the forum rules). However, it would also be helpful if you put together your own sample workbook and post it in this thread. Indicate clearly what you have and what you would like to achieve (e.g. by having a BEFORE and AFTER sheet).

Hope this helps.

Pete

Hi Again

Thanks for such a quick response

No problem at all

Please see Column B

This shows if a word appears from the list in column F but only shows the last result which appears.

I wish for the formula to be able to show all results

The formula used is =IF(SUMPRODUCT(COUNTIF(A4,"*"&$F$2:$F$6&"*"))=0,"None Found",INDEX($F$2:$F$6,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($F$2:$F$6,A4)),),0)))

For example the list is

BMW
Ford
Honda
Mercedes
Toyota

and it is searching

Bob's Ford BMW
Mercedes And Honda of ABC
Smith BMW
Ford USA
Tim's Honda
Randy's Toyota Dealer
BMW Superstore


Currently the results would be as follows

BMW
Honda
BMW
Ford
Honda
Toyota
BMW

but I would want the results to be

Ford,BMW
Mercedes,Honda
BMW
Ford
Honda
Toyota
BMW

Therefor showing all of the words which occur in the list.

I have attached the excel sheet for reference

Thanks

Can Anyone assist with this if possible please?

Hi There

Thanks for responding,

I honestly would not know where to begin in doing that I am afraid

is there anything you could assist with in getting us there?

Thanks

Hi Again

That is perfection its self

Thank you ever so much, it seems to work perfectly!

You have saved me a great amount of time, it is extremely appreciated!

This issue is most certainly solved!

Thanks again!