How to add data linked to the drop down choices

Occasional Visitor

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!

1 Reply
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.