drop down list question and assistance

[mrgreeneyes]

Hello,

I need help with a spreadsheet I'm working on.
I am trying to have 2 drop down lists and based of the entry in each list I would like a cell to list the specific info that is related to the two choices in the drop down lists.

Drop Down list 1 Drop Down list 2

Name of client Team


Cell - to show the info about the team member, that will be pulled from another sheet?

is it possible?

 

[James006]

Hello,

Have a look at following link :

https://www.contextures.com/xlDataVal02.html

Hope this will help