Hello
i have an issue where i am trying to search for a part of text string within an array of strings from another array string list. For example in column A i might have
Walmart
Honda
TVA
Redstone arsenal
BASF
HCS-Hoover
Safeway
3M Building 278 - 3M Center - St. Paul
3M - Building 255 - 3M Center - St Paul
84 Lumber 601 (IL)
3M - Cottage Grove - Cottage Grove, MN
Accenture - All Locations
Accenture - All Locations
Aera Energy - Bakersfield 29235 (CA)
ADT Security 2720 (AZ)
column B i have items i want to find in column A but they are generally a subset of whats in A.
3M
84 lumber
Accenture
ADT - Tyco
Aera energy
So i want to be able search the entire list in A with the Entries in the B array and come back and say "yes" it found it or no it didnt. I have tried some search,find and index functions but i keep getting !VALUE errors or the wrong results. What is the right way to do this?
thanks
Bookmarks