Need Ideas for a Bill of Materials document

[iamhere13270]

Hello,

I'm looking for ideas on how to make a bill of materials where the materials list gets filled in automatically with just a few inputs from the end-user. There will be three sheets in total: Input, DATA, and BOM.

The inputs will be the following: Product Model, Main color, Trim color.

Input

Product	Color
Product A	Black/Red
Product A	Red/Grey

<tbody>
</tbody>

The output should look similar to this:

This is a photograph of a manually filled form that we've been using. So, for example: Product A Black/Red's materials will be listed alongside with Product A Red/Gray's materials. However, the quantity of the materials required for the products will be separated into different columns.

I'm trying to figure out a way to have Excel fill in this type of table for me.

I was thinking about filling in a table on a separate sheet called "DATA" with product material requirements for each model. When I input something into the Input table inside the "Input" sheet, two new columns have to be created, and they have to be filled for me. I'm figuring out a way for Excel to pull the information from the "DATA" sheet and paste them into the "BOM" sheet

Thanks a lot!