Would "lookup" work for this?
I have 2 sheets with similar data. Both are for orders placed by the
customer. But both sheets have different part numbers as well as the same
part numbers. What I am trying to do is pull from sheet 2 all the part number
orders and place on sheet 1.
For example Sheet 1:
Part No. 6/17 6/24 6/30
12334 2 4 3
12335 3 4 2
12337 2 2 0
18494 1 1 1
Sheet 2
Part No. 6/17 6/24 6/30
12331 1 1 1
12334 7 2 2
12337 2 8 4
17854 1 2 4
Would like to have the number of orders needed from sheet 2 sent to sheet 1,
appending them at the end of the columns with dates.
Part No. 6/17 6/24 6/30 6/17 6/24 6/30
12334 2 4 3 7 2
2
12335 3 4 2
12337 2 2 0 2 8
4
18494 1 1 1
Any help is most appreciated.
|