Lets say I have the following spreadsheet.(adsbygoogle = window.adsbygoogle || []).push({});

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?Code (Text):

A B C D E

1 Ingredient Calories Protein Recipe Calories

2 Banana 100 1 =A2 ?

I hope the way I worded this question makes sense.

**Physics Forums - The Fusion of Science and Community**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel Problem

Loading...

Similar Threads for Excel Problem | Date |
---|---|

Ratio of Fields from Different Sheets in Excel Pivot | Jan 23, 2018 |

Strange problem with Excel | Aug 6, 2014 |

Excel Problems with error bars | Feb 11, 2013 |

Frustrating excel problem with COS | Feb 27, 2012 |

Small Coding Problem for Excel Macro | Jul 2, 2010 |

**Physics Forums - The Fusion of Science and Community**