Thanks for the all help, it looks like a few of them will work so i have
choices.

"T. Valko" wrote:

Maybe this:

=IF(COUNTIF(A$2:A$100,"*"&B2&"*"),"Found","Not Found")

--
Biff
Microsoft Excel MVP


"NewAccessDude" wrote in message
...
Hello,

I have been playing with both the vlookup and the index(match) functions
and
I need some help.

I have 1 column of data and I need to see if 13 words are contained
anywhere
in that column. For example: I need to see if anything from column B is in
Column A. Any and all help would be appreciated

Column A (just a sample) Column B
6-Hexanelactam (epsilon-caprol Aircraft
6-Hexanelactam (epsilon-caprol atv
6-Hexanelactam (epsilon-caprol Auto
6-Hexanelactam (epsilon-caprol Bars
6-Hexanelactam (epsilon-caprol boat
6-Hexanelactam (epsilon-caprol Corn
6-Hexanelactam (epsilon-caprol Forklift
6-Hexanelactam (epsilon-caprol grain
6-Hexanelactam (epsilon-caprol Household
6-Hexanelactam (epsilon-caprol motorcycle
6-Hexanelactam (epsilon-caprol Personal
6-Hexanelactam (epsilon-caprol Scrap
6-Hexanelactam (epsilon-caprol soybean
Acyclic monoamines, their deri
Agricultural/horticultural/for
Aluminum foil not backed not o
Aluminum foil not backed not o
Aluminum foil not backed not o
Aluminum plates, sheets & stri
Antennas and antenna reflector
Antennas and antenna reflector
Antennas and antenna reflector
Antennas and antenna reflector
Apple juice, unfermented
Apple juice, unfermented
Apple juice, unfermented
Apple juice, unfermented
Apple juice, unfermented
Articles & equipment for sport
Articles for pocket or handbag
Articles of apparel & clothing
Articles of apparel & clothing
Articles of apparel & clothing
Articles of iron or steel
Articles of iron or steel
Articles of iron or steel
Articles of iron or steel
Articles of iron or steel
Articles of iron or steel

thanks!