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?