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
Bookmarks