•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using a drop down menu's selection in a formula?
So say I have a table of data E1:G3
I'd like a cell "A1" to have a drop down menu, that drop down menu references E1:E3 so options are "Name 1", "Name 2"....
cell "A2" looks at A1 and displays the contents of a cell that column (E:2)
cell "A3" looks at A1 and displays the contents of a cell that column (E:3)
is it possible to reference location of a selection in a drop down?
[link] [comments]
Want to read more?
Check out the full article on the original site