Lookup by using drill down function

[Michael Siglev]

Hi, in the attached example, in the sheet "Front page" I want to be able to choose specific participants, who are involved in specific projects. I guess I need two drill down functions, one related to project type, and one related to project participants. These drill down functions needs to be based on the data sheet. For an example, if I choose project A in the drill down function on my Front page, I can choose between Lone, Lex and Richard in the Project Participant function.

Hope that someone has the solution to the above problem.

Best regards

Michael

[Kyle123]

I think you're looking for dependant dropdowns - http://www.contextures.com/xlDataVal13.html

Does that help?

[Michael Siglev]

Yes I think your right, I will try that.

Thanks alot for your fast respons

/Michael