- #1
FrogPad
- 810
- 0
Lets say I have the following spreadsheet.
Now what I want to do is let's say I click on cell D2 and type "=A2" (without quotes of course). What happens is that D2 would then equal "Banana". How could I automatically make E2 fill in the appropriate amount of calories for banana?
I hope the way I worded this question makes sense.
Code:
A B C D E
1 Ingredient Calories Protein Recipe Calories
2 Banana 100 1 =A2 ?
Now what I want to do is let's say I click on cell D2 and type "=A2" (without quotes of course). What happens is that D2 would then equal "Banana". How could I automatically make E2 fill in the appropriate amount of calories for banana?
I hope the way I worded this question makes sense.