Using VLOOKUP to get multiple values from another sheet.

Hello everyone,

So I have this problem which I face with the attached form.
when I fill in the data in sheet "PL_FORM" it's automatically transferred to the sheet "AS_FORM" as you can see in the attached file, it gives the data along with all its information (STYLE, COLOR, SIZE, and NUMBER OF PIECES). BUT my problem is with the rows as in row no. 14 in sheet "PL_FORM", I have two sizes and two number of pieces in the same box (here box no. 1 and 5) but I only get the first size and the first number of pieces; that's why I have to go to the sheet "AS_FORM" and insert a new row and copy-paste the correct date from "PL_FORM" to "AS_FORM"; and honestly it takes forever to do it because sometimes I have more than 200 box and I have to check them all one by one.

Can you please help me with this?

Thanks in advance.

Cheers.

My first thought is to either have a size column following B and C so each row can only have a single column for each size (and you wouldn't need sever columns for sizes, you could have size codes 1-7 or us the alphanumeric text). Or you could change the style to have an additional two characters by adding "-1" for Small, "-2" for Medium, etc. Then each would be unique.

I'm sorry but I'm not sure that I understand what you meant? would you please clarify it on the form?

thank you!

Here's a sample of what I was thinking . . .

unfortunately, I can't use the form which you've suggested because my costumer needs both PL_FORM and AS_FORM as they are; these are forms which I can't change anything with them because if I do it'll give a huge problem in their systems.

Thank you very much for your suggestion anyway