I need to pull prev yr sales data from a certain customer on a tab that has all customers data listed to another tab. I need to match customer # and item # to get correct specific info. Any suggestions?
<tbody>
</tbody>
Item # | cust # | Customer name | Description | Packaging | Case Qty | Total Sales $ |
100382 | 111111 | SLAY'S FIREWORKS | 20 | 2044.62 | ||
100748 | 111111 | SLAY'S FIREWORKS | 40 | 3925 | ||
200095 | 111111 | SLAY'S FIREWORKS | 10 | 633.5 | ||
100382 | 111112 | ADAY's FIREWORKS | 5 | 237.56 | ||
100748 | 111112 | ADAY's FIREWORKS | 20 | 1411.12 | ||
<tbody>
</tbody>