I am trying learn how to create a new row of date when there is a duplicate entry in a column. What I am doing, is trying to figure out when someone purchases product A, what product B are they also purchasing. So I have two sheets of data, sheet 1 lists the invoice #'s and which product A they purchased; sheet 2 lists the invoice#'s and which product B they purchased. I created a column in sheet 2 for product A, and I have been using the formula "=INDEX(Sheet1!B:B,(MATCH(Sheet2!A2,Sheet1!A:A,0)))" This formula works for great for matching product A with product B, but it does not take into account when more than one Product A or Product B was purchased on the same invoice.
I have attached a sample document. Any help would be greatly appreciated. Thanks!
Bookmarks