|
Lorenzo, tx | Don't laugh I had to use my phone to get a screen shot. I know how to get it to reference a cell, this is a step farther. What I want is when I select Corn from my drop down box I want it to reference the cell with the price I have for corn, then when I change that box to cotton I want it to automatically references the cell with the price I have for cotton does that make any more sense? This is different than just making one cell equal another it making one cell equal another when the first cell is changed to whatever is in my drop down box. I have to keep my Drop down box becasue that's what I use to reference my variable expenses.
Edited by WTXCottonguy 2/19/2015 18:58
 (image.jpg)
 (image.jpg)
Attachments
----------------
 image.jpg (205KB - 110 downloads)
image.jpg (183KB - 102 downloads)
| |
|
excel question.
