Please choose the number value according to the quantity

[111398 (찬희 한)]

I’m trying to get the number from column A in sheet1 to column K in the purchase sheet by matching Vlookup to column c in sheet1 and column A in the purchase order detail sheet!(If quantity is 2, 632123501446, 632123501472)
If it’s 3, 632123501446, 632123501472,6666666611) I’m trying to distinguish “,” so what should I do?

If you use vlookup, the part with 2 values ​​is duplicated at the bottom. What is the way…2020-07-02.xlsx (12.9 KB)