Copper Contributor

I have a list of food that the user will select from a drop down list. each food has a value. Based on the selection I want another cell to print this value.

For example: Cell A1: A10 has names of food. Cells B1: B10 and C1:C10 has values of protein and fats based on the food. In Cell D1 there is a drop-down list. The user selects rice. I want Cell E1 to show the amount of protein and cell F1 to show the amount of fats.

1 Reply


In E1:


In F1:



If you have Microsoft 365 or Office 2021, you can enter this formula in E1. It will automatically spill to F1:



All these formulas can be filled down if required.