PLEASE HELP to Extract Text from String

[HotNumbers]

Can someone PLEASE help me extract text from a string using a table for reference
I have the current formula
=IF(ISERROR(SEARCH("*home*",Q30,1)),"","home") However in the Place of "*home*" i want to reference a table for words and in the Place of "home" I want to be able to return the word that it matched.

 

[T. Valko]

Can someone PLEASE help me extract text from a string using a table for reference
I have the current formula
=IF(ISERROR(SEARCH("*home*",Q30,1)),"","home") However in the Place of "*home*" i want to reference a table for words and in the Place of "home" I want to be able to return the word that it matched.

See your other post:

http://www.mrexcel.com/forum/showthread.php?t=555892

 

[HotNumbers]

Thanks everyone for your help... But this is not excactly what i am looking to do. the video show an example of only 2 match, i have a table of matches, I also want it not to return true or false but the actual text matched.

 

[T. Valko]

Thanks everyone for your help... But this is not excactly what i am looking to do. the video show an example of only 2 match, i have a table of matches, I also want it not to return true or false but the actual text matched.

How about posting any replies to your other thread.

Now we have to jump back and forth to see what you're talking about.

The formula I suggested in the other thread does not return TRUE and/or FALSE. I didn't watch that video so I don't know what it suggested.

Please post any replies to the other thread.

 

[HotNumbers]

My deepest apologizes , I have been having some system issues and my posts were not showing on my system. However I did get the reply I needed from AKASHWANI. Here is the answer from my prior posts
http://www.mrexcel.com/forum/showthread.php?p=2746166#post2746166