Is it possible to use a drop down menu to populate multiple cells on another page?

[scirone]

I am wanting to create a workbook where I can have :

Database.JPG
1. A pre-populated database sheet with a list of tasks and the material needed for that task


Task Entry.JPG
2. A sheet when I can select tasks from a drop-down menu and assign a task identifier code


Material Required.JPG
3. A sheet that will populate the materials needed for the tasks from the task selected on the previous sheet and display the task identifier number that it is required for next to the materials (I dont need the name of the task displayed, just the identifier number).

Is creating this kind of workbook possible?

[Richard Buttrey]

Yes indeed. It's a very common task.

Upload your workbook with the various tables and then manuallyadd a couple of examples of the results you expect to see for any selections you make. Clearly state which are the input cells for selection and which is your results range.

[Fotis1991]

Yes it is. Take a look to INDEX & MATCH functions.