searching for specific text

well, maybe you'll know how to do it with the bigger picture. I'll give you
an ‎example: there is a textbox column that might contain the sentence "a box
of ‎chocolate". I have another column that needs to say what kind of candy
(from a ‎known list of possibly candy) it is the first column. now I need a
function that will ‎automatically finds which of the keywords is in the
textbox column and gives the ‎answer in the second column.‎

Hello,
If you do not get a reasonable response, please send the workbook to:
excelmarksway@yahoo.com.au

Any confidential information received will not be shared with any persons,
living or presumed dead.

http://www.geocities.com/excelmarksway


"clerk" wrote:

> well, maybe you'll know how to do it with the bigger picture. I'll give you
> an ‎example: there is a textbox column that might contain the sentence "a box
> of ‎chocolate". I have another column that needs to say what kind of candy
> (from a ‎known list of possibly candy) it is the first column. now I need a
> function that will ‎automatically finds which of the keywords is in the
> textbox column and gives the ‎answer in the second column.‎