Lets say I have the following spreadsheet. Code (Text): A B C D E 1 Ingredient Calories Protein Recipe Calories 2 Banana 100 1 =A2 ? Now what I want to do is lets 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.