Hi
I have created a spreadsheet to calculate manufacturing costs of a product
I have 6 rows B to G
I would like a drop down selection box in column B (An ingredient list) - Then I would like the cost per kg to populate into column E
I was going to have a separate sheet with columns A (ingredients) and B (cost per kg in £)
Im not really sure how to do this and then pull the data into my spreadsheet.
Can someone help please?
Thanks