V Lookup - How to do this please?

asked 2017-01-05 19:20:50 +0100

Funky gravatar image

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

edit retag flag offensive close merge delete