Greetings, Im trying to figure out how to do the following, any help would be appreciated.
Basicallt, i need to enter in a drop down menu a finished product and de-construct it into inventory needs

Cell A1 and B1 are drop down menus with the same choices. Let's say choices are 1; 2; 3 (finish product)


Cells D1 to F1 are materials

I need to return values to multiple cells depending on choice made in A1...

IE: i need +3 in D1 and + 4 in F1 if drop down =1
I need +5 in E1 and +6 in F1 if drop down =2
I need +7 in D1, +8 in E1 and +9 in F1 if drop down=3

Thanks