lookup.xlsx

To make this easier, I have attached a dummy sheet with three rows of data. 2 of the 3 customers are on both lists, one from each is unique.