I've got 2 sheets of downloaded SAP data.One sheet is a list of customer names and the other list is supplier names.
One list may have the name as ABC company,Inc and the other may say
ABC co,and so on.
Both lists have other,un-needed data.
What I want to do is find the customers(by name) that are also suppliers( by name).
I've tried the basic match,lookup,if and Vlookup without much luck.