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 matches the customer name, catalog # and order # in the rebate report, I want to insert the customers name in Column E. Thanks for the help.
Product sales report
COL A Customer ID | COL B | COL C | COL D |
Rebate report
COL A Customer Name............. | COL B Catalog Number.......................... | COL C Order #....... |
1 Reply
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.
