Hello:
I am trying to compare data across two worksheets, and if the data in a particular row matches, copy data from second worksheet to the first worksheet. Not sure how to get started. My workbook is attached.
Worksheet #1, Concierge Elite, contains customer orders. Worksheet #2, Carpet Pad Lookup contains a table that lists a bill of materials for a particular qty, width and depth of a customer order.
If these records match:
Sheet1, Column I = Sheet2, Column A
and
Sheet1, Column L = Sheet2, Column B
and
Sheet1, Column M = Sheet2, Column C
If rows match across all columns, then I want the values in (Sheet2, Columns D-G) copied into (Sheet1, Columns N-Q).
I am looking for a formula to make that happen.
In the end, I want to find out how many of each color pad color I need to complete all orders. But, as long as that data is copied into Sheet1, I'm sure I could figure out a simple pivot table to do that part.
I hope this makes sense!
Bookmarks