•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#AI formula generation techniques
#drop down menu
#table of data
#cell
#reference
#options
#selection
#E1:E3
#A1
#display
#contents
#formula