Drop down data extraction

[MrFormat]

Hi All,

I’ve have a simple function I want to create on my spreadsheet but I’m finding it difficult to achieve it.

I want to select a name from a drop down menu and dependant on the name select I want to populate data in a static column.

I have created the drop down menu for example:

John
Dave
Sam
Jay
Ray
Rosie

I have a targets column on my spreadsheet, so I I select Dave then saves targets will appear, for example:

Dave (drop down)

A1 B1
PTC 50
REC 49
RPA 33
VIR 70




Column A1 will remain static however B1 target data will change as you select a different name.

I would be grateful if anyone can help, I have very basic knowledge of excel which I’m working on improving.

Thank you in advance

 

[Yuriy B]

Since you know how to do drop downs, what you want is called indirect.
The formula is "=Indirect(whatever cell you have your names in)" Without quotes

For a complete explanation on indirect follow this simple guide: https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/

 

[MrFormat]

Since you know how to do drop downs, what you want is called indirect.
The formula is "=Indirect(whatever cell you have your names in)" Without quotes

For a complete explanation on indirect follow this simple guide: https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/

Thank you for a quick response. I will try this and let you know how I get on.