Displaying data based on drop-down menus (Index/Match help needed)

Hi,

have a look at the attached. I've created the range name "jobs" on the Database tab to use it in the data validation list on the Summary tab.

Also some suggestions on the range name for the Duty data validation (see inside the workbook).

Your formula basically is:

=IF(ISBLANK(B5),"",VLOOKUP($B$2,Database!$A$3:$D$7,MATCH(Summary!B5,Options,0)+1,FALSE))

This will work as long as there is only one row per job in the Database.

Hope that helps