Hi I am very new to excel and I need your expertise :)
I would like to be able to click on one of the drop down menu options then I would like data to appear on the 2 cells next to the drop down menu. Is this possible? Thanks!
It’s possible. The data must be present in a range/table which provides the input list to the dropdown. You can then use the filter or other formulas to get the required data into the cells based on the dropdown selection.
