Ok, I've attached a sample workbook.
There are two tabs, one representing the Database, and one representing the Summary-Sheet.
What I'm looking to do is, on the Summary-Sheet, enter a job-number on top (in this case, "Atown", "Btown", or "Ctown"), and then click one of the drop-down menus ("Duties"), with the result next popping up next to it.
For instance, if I enter job-name "Atown", and pick "Clean Stuff", I want "3" to pop up next to it.
Thanks a lot.
Bookmarks