I have a column of car manufacturers BMW, Ford, Acura, Chevorlet etc. and I also have a list of auto dealers like Bob's Ford, BMW of Anytown, or Smith Chevorlet. I want to check if the auto dealers list contains the text from my list of car manufacturers and then return the value from the list in the adjacent cell.
So.....
A1 A2
Bob's Ford Formula to reference "Ford"
Any help is appreciated. Thanks.
Bookmarks