Spreadsheet: 267830d1380224452-compare-data-across-worksheets-and-copy-data-if-match-carpet-pad-example
Sheet: Carpet Pad Lookup (2)

 | Quantity | [NAME] | Depth | Group | Subgroup | Part | Pad color | Qty | Pad color | Qty | BOM
 | 90 | 8 | 10 | 5 | 80 | 2 | Pink | 1 |  |  | Pink
 | 160 | 8 | 20 | 5 | 80 | 2 | Green | 1 |  |  | Green
 | 240 | 8 | 30 | 5 | 80 | 2 | Black | 1 |  |  | Black
 | 100 | 10 | 10 | 5 | 80 | 2 | Red | 1 |  |  | Red
 | 180 | 10 | 20 | 5 | 80 | 2 | Green | 1 |  |  | Green
 | 200 | 10 | 20 | 5 | 80 | 2 | White | 1 |  |  | White
 | 270 | 10 | 30 | 5 | 80 | 2 | Black | 1 |  |  | Black
 | 300 | 10 | 30 | 5 | 80 | 2 | Blue | 1 |  |  | Blue
 | 400 | 10 | 40 | 5 | 80 | 2 | White | 2 |  |  | White, White
 | 500 | 10 | 50 | 5 | 80 | 2 | White | 1 | Blue | 1 | White, Blue
 | 600 | 10 | 60 | 5 | 80 | 2 | Blue | 2 |  |  | Blue, Blue
 | 700 | 10 | 70 | 5 | 80 | 2 | Blue | 2 | Red | 1 | Blue, Blue, Red
 | 800 | 10 | 80 | 5 | 80 | 2 | Blue | 2 | White | 1 | Blue, Blue, White
 | 900 | 10 | 90 | 5 | 80 | 2 | Blue | 3 |  |  | Blue, Blue, Blue
 | 1000 | 10 | 100 | 5 | 80 | 2 | Blue | 2 | White | 2 | Blue, Blue, White, White
 | 400 | 20 | 20 | 5 | 80 | 2 | White | 2 |  |  | White, White
 | 600 | 20 | 30 | 5 | 80 | 2 | White | 3 |  |  | White, White, White
 | 800 | 20 | 40 | 5 | 80 | 2 | White | 4 |  |  | White, White, White, White
 | 1000 | 20 | 50 | 5 | 80 | 2 | White | 5 |  |  | White, White, White, White, White
 | 1200 | 20 | 60 | 5 | 80 | 2 | White | 6 |  |  | White, White, White, White, White, White
 | 1400 | 20 | 70 | 5 | 80 | 2 | Blue | 4 | Red | 2 | Blue, Blue, Blue, Blue, Red, Red
 | 1600 | 20 | 80 | 5 | 80 | 2 | Blue | 4 | White | 2 | Blue, Blue, Blue, Blue, White, White
 | 1800 | 20 | 90 | 5 | 80 | 2 | Blue | 6 |  |  | Blue, Blue, Blue, Blue, Blue, Blue
 | 2000 | 20 | 100 | 5 | 80 | 2 | Blue | 4 | White | 4 | Blue, Blue, Blue, Blue, White, White, White, White
 | 900 | 30 | 30 | 5 | 80 | 2 | Blue | 3 |  |  | Blue, Blue, Blue
 | 1200 | 30 | 40 | 5 | 80 | 2 | Blue | 4 |  |  | Blue, Blue, Blue, Blue
 | 1500 | 30 | 50 | 5 | 80 | 2 | Blue | 5 |  |  | Blue, Blue, Blue, Blue, Blue
 | 1800 | 30 | 60 | 5 | 80 | 2 | Blue | 6 |  |  | Blue, Blue, Blue, Blue, Blue, Blue
 | 2100 | 30 | 70 | 5 | 80 | 2 | Blue | 6 | Red | 3 | Blue, Blue, Blue, Blue, Blue, Blue, Red, Red, Red
 | 2400 | 30 | 80 | 5 | 80 | 2 | Blue | 6 | White | 3 | Blue, Blue, Blue, Blue, Blue, Blue, White, White, White
 | 1600 | 40 | 40 | 5 | 80 | 2 | White | 8 |  |  | White, White, White, White, White, White, White, White
 | 2000 | 40 | 50 | 5 | 80 | 2 | White | 10 |  |  | White, White, White, White, White, White, White, White, White, White
 | 2400 | 40 | 60 | 5 | 80 | 2 | White | 12 |  |  | White, White, White, White, White, White, White, White, White, White, White, White
 | 2500 | 50 | 50 | 5 | 80 | 2 | White | 5 | Blue | 5 | White, White, White, White, White, Blue, Blue, Blue, Blue, Blue
 | 90 | 10 | 8 | 5 | 80 | 2 | Pink | 1 |  |  | Pink
 | 160 | 20 | 8 | 5 | 80 | 2 | Green | 1 |  |  | Green
 | 240 | 30 | 8 | 5 | 80 | 2 | Black | 1 |  |  | Black
 | 180 | 20 | 10 | 5 | 80 | 2 | Green | 1 |  |  | Green
 | 200 | 20 | 10 | 5 | 80 | 2 | White | 1 |  |  | White
 | 270 | 30 | 10 | 5 | 80 | 2 | Black | 1 |  |  | Black
 | 300 | 30 | 10 | 5 | 80 | 2 | Blue | 1 |  |  | Blue
 | 400 | 40 | 10 | 5 | 80 | 2 | White | 2 |  |  | White, White
 | 500 | 50 | 10 | 5 | 80 | 2 | White | 1 | Blue | 1 | White, Blue
 | 600 | 60 | 10 | 5 | 80 | 2 | Blue | 2 |  |  | Blue, Blue
 | 700 | 70 | 10 | 5 | 80 | 2 | Blue | 2 | Red | 1 | Blue, Blue, Red
 | 800 | 80 | 10 | 5 | 80 | 2 | Blue | 2 | White | 1 | Blue, Blue, White
 | 900 | 90 | 10 | 5 | 80 | 2 | Blue | 3 |  |  | Blue, Blue, Blue
 | 1000 | 100 | 10 | 5 | 80 | 2 | Blue | 2 | White | 2 | Blue, Blue, White, White
 | 600 | 30 | 20 | 5 | 80 | 2 | White | 3 |  |  | White, White, White
 | 800 | 40 | 20 | 5 | 80 | 2 | White | 4 |  |  | White, White, White, White
 | 1000 | 50 | 20 | 5 | 80 | 2 | White | 5 |  |  | White, White, White, White, White
 | 1200 | 60 | 20 | 5 | 80 | 2 | White | 6 |  |  | White, White, White, White, White, White
 | 1400 | 70 | 20 | 5 | 80 | 2 | Blue | 4 | Red | 2 | Blue, Blue, Blue, Blue, Red, Red
 | 1600 | 80 | 20 | 5 | 80 | 2 | Blue | 4 | White | 2 | Blue, Blue, Blue, Blue, White, White
 | 1800 | 90 | 20 | 5 | 80 | 2 | Blue | 6 |  |  | Blue, Blue, Blue, Blue, Blue, Blue
 | 2000 | 100 | 20 | 5 | 80 | 2 | Blue | 4 | White | 4 | Blue, Blue, Blue, Blue, White, White, White, White
 | 1200 | 40 | 30 | 5 | 80 | 2 | Blue | 4 |  |  | Blue, Blue, Blue, Blue
 | 1500 | 50 | 30 | 5 | 80 | 2 | Blue | 5 |  |  | Blue, Blue, Blue, Blue, Blue
 | 1800 | 60 | 30 | 5 | 80 | 2 | Blue | 6 |  |  | Blue, Blue, Blue, Blue, Blue, Blue
 | 2100 | 70 | 30 | 5 | 80 | 2 | Blue | 6 | Red | 3 | Blue, Blue, Blue, Blue, Blue, Blue, Red, Red, Red
 | 2400 | 80 | 30 | 5 | 80 | 2 | Blue | 6 | White | 3 | Blue, Blue, Blue, Blue, Blue, Blue, White, White, White
 | 2000 | 50 | 40 | 5 | 80 | 2 | White | 10 |  |  | White, White, White, White, White, White, White, White, White, White
 | 2400 | 60 | 40 | 5 | 80 | 2 | White | 12 |  |  | White, White, White, White, White, White, White, White, White, White, White, White