Matching multiple columns in 2 spreadsheets

[David]

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 Customer Name

COL C Catalog #

COL D Order Number

Rebate report

COL A Customer Name.............

COL B Catalog Number..........................

COL C Order #.......

[#2]

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.