Hi All,
Attached is an example of a spreadsheet I extract on a monthly basis. The problem is that each branch name appears only once in the same column (A) as the sold products in Sheet1. What formula can I use to get the store name to appear next to each of the sold products as shown in sheet2?
Example.xlsx
Bookmarks