I received a spreadsheet with a list of customers (around 200) that I need to find in another larger spreadsheet (column with around 2K customers) in order to obtain their ID code. What is the easiest way to do so? The column with the larger number of customers has a filter, which I could use to find one or two customers, but with such a large list that will take me forever. I could use IF functions but I need to know exactly which customers from my small list were found in my large list.
Hope its not too confusing!
Thanks in advance!!!
Hope its not too confusing!
Thanks in advance!!!