Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup or index(match)?
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup or index match??? | Excel Discussion (Misc queries) | |||
Index/Match or Vlookup | Excel Worksheet Functions | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
VLookup or Index Match ? | Excel Worksheet Functions |