Forum Discussion
Matching multiple columns in 2 spreadsheets
I have 2 monthly spreadsheets (example of column formats below): 1. A rebate report 2. Products sales spreadsheet Where the customer name, catalog # and order number in the product sales report...
Hi!
In order to do that, one of the variables must be unique, which in this case, would be order number. Then, you can use the INDEX & MATCH functions to look for the value at the Product report and return into the Rebate report.