I have a list in Sheet2 J3:J7
of calculated values.
I would like to insert it as a drop down list into Sheet1 B10
, which is simple enough, however:
I want the list to use the words: apple (J3
), banana (J4
), grapes (J5
), orange (J6
), pineapple (J7
) rather than the calculated values, yet the cell B10
goes onto be used in other calculations, so although the fruit name will appear - its associated formula needs to, somehow, be in there too, in order to be used in the calculations...
Make sense? Any Ideas?