Hello All -
I'm new here and looking for help. I have basic knowledge of excel and functions. But what I'm trying to do I am frustrated with.
What I'm looking to do:


I have a two sheets. Sheet 1 is the user sheet. Sheet 2 is the Inputs sheet. (where all allowable data is)
I have made a drop down list in a cell.
I would like another cell to populate data in a drop down list from the inputs sheet depending on what the first drop down list populates. This data it needs to populate is not in a list but in in different cells i.e. K2,K4,k8.

Any help would be great.

Thanks

Dave