Dropdown Formula Help

[block1nm]

Hello all,

I am having an issue with pulling information from drop down menus and different worksheets and getting that information to populate in a master worksheet.

Essentially, i have these worksheets: Calendar View (Master Worksheet), Employee Audit Tracker, List of Employees, Audit Types

My staff undergo a bunch of audits and certifications over their tenure at my company. The employee audit tracker allows me to have dropdown menus with the employee, then a date, type of aduit and then metric scores. The master worksheet pulls all of this information into a cohesive page when i can click on a drop down menu and pick an employee. The problem is, i can't get each employee to populate the proper information. I attached the workbook mentioned above. any help is greatly appreciated

UPDATE:

I got the information to pull properly, but now i am struggling with getting the type of audit drop down menu to link with the individualized data for each employee. Again, help is greatly appreciated

Audit Workbook.xlsx

[block1nm]

I apologize for double attaching the document

[JeteMc]

Hello block1nm and Welcome to Excel Forum.
I am guessing that since the name of the audit is "30 day self audit" it will occur multiple times in a year and you want an average as opposed to a sum.
A formula that could be used is:

Please Login or Register  to view this content.

Note that the LeaveTracker table has been resized to include columns F:H.
Let us know if you have any questions.