Does not seem to be too difficult but the sample is too short to see the
details you require.

Cheers

"The Moose" wrote in message
ps.com...
I have three columns -- product-name, company-category,
product-description.

I'd like to search through these three columns for a list of keywords.
If the keyword or keywords exist, I want to enter it into a list.

For example, search through column1 & column2 & column3 for the words
basket, vase, wicker, red and return the matching words; e.g.:
basket, wicker, red
vase, red

Some products might fall into 6 or 8 different keywords. I only need
to get 3 or 4 of them into a list.

I've been looking at match, vlookup, index -- I'm assuming it's
probably some combination of these. I just can't get my head around
it.

Oh, the other problem is column3 (product-description) contains HUGE
volumes of text sometimes. I didn't create this thing. I only need to
search through the first 100 or so characters. I've seen a way to
limit the search on a large text field so you don't run into that
famous/helpful "formula is too long" message. Can't remember where I
saw it though.

Thanks.

Barb