Reply to thread

If I have 2 drop down boxes can I set up a formula so that depending on what value is selected from the drop down boxes (worded selections) it then displays a result in a third box.

For example, the first drop down box are tasks and the second drop down box are departments. Can I then, depending on what someone selects, then display, for example, someone's name?

Also is an excel spreadsheet the best way to achieve this or is there something better?

I got as far as dependent drop down boxes via tutorials but I can't find a way to marry it all up.