Creating an order form from a model number

[TommyD]

Hi all,
I have a report that I pull from our ERP system. It gives me a list
of data like the following:

Model SKU Size
1234 56789980 md
1234 65898982 lg
1234 56987985 xl
2345 89887878 md
2345 98565232 lg

I am trying to make an easier form to for ordering where I can input
the model and have the sku's populate into a specific column and
section of fields for instance:

Model 1234 put in on the order form and all the sku's would populate
into the six column beneath it. I hope this makes sense. I am not sure
how to do this. Thanks!

 

[M Kan]

Model number or SKU, since model number isn't a unique identifier, but SKU
is. If you want to reference off the SKU, you'd just use a VLOOKUP to match
and then bring the associated information back into your order form.

 

[John C]

If you type in a model number, are there 6 different sizes? Thus 6 different
SKU's?