Hey Excel Gurus,

I need to write a formula that will find a name on a data sheet and then take the date in that same row and fill it into a specific cell in a table to show when an inspection was completed.

Inspection Tracker (Sheet one) is a table that has names on the left, column A. And a grid set up with the months along the top, numbered 1-12. the are that they occupy is C3:N23

Data (Sheet 2) is the data sheet with the following Column fields:
Checklist(A) - Status(B) - type(C) - Inspector(D) - Completion Date(E)

so when I update the data sheet, I want the formula to find the name in the Data sheet and return the date the inspection was completed to the appropriate cell on the inspection tracker sheet.