If the words you're looking for is exactly what would be found in column A,
then
=IF(ISNUMBER(MATCH(B2,A2:A100,0)),"Found","Not Found")
entered into C column and copied down would let you know if a word from
column B was found in your list.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"NewAccessDude" wrote:

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!