Hey All,
Would appreciate your help here.
Please see the attached excel file.
My problem statement is rather simple, but I was hoping that someone could guide me here;
The first tab in the file (titled "Data Set") has 4 part types (P1,P3...) listed in the first row. The numbers below in each column are specific to that part type only.
On the second tab in the file (titled " Placement Sheet") I have only the part types in the first row, which are arranged randomly.
My task is to figure out where each part type of the "Data Set", is located on the "Placement Sheet", and subsequently copy the numbers on the "Placement Sheet" under the correct part type.
This is the sample data , but in reality I'm dealing with 100s of part types on the "Placement Sheet" and so wanted to know if this can be done quickly via Index &Match (perhaps using arrays?) or something faster
Your help is much appreciated.
Kind Regards,
Avi
Would appreciate your help here.
Please see the attached excel file.
My problem statement is rather simple, but I was hoping that someone could guide me here;
The first tab in the file (titled "Data Set") has 4 part types (P1,P3...) listed in the first row. The numbers below in each column are specific to that part type only.
On the second tab in the file (titled " Placement Sheet") I have only the part types in the first row, which are arranged randomly.
My task is to figure out where each part type of the "Data Set", is located on the "Placement Sheet", and subsequently copy the numbers on the "Placement Sheet" under the correct part type.
This is the sample data , but in reality I'm dealing with 100s of part types on the "Placement Sheet" and so wanted to know if this can be done quickly via Index &Match (perhaps using arrays?) or something faster
Your help is much appreciated.
Kind Regards,
Avi
Attachments

9.4 KB Views: 11