Lookup specifics & Match data & record a date between 2 sheets
From a single report sheet (A) in (Grid View) named:
· “Adelaide Annual WHS Calendar”
o Description: (column title)
Various “individual” inspections areas
I am trying to look up in a “Workplace Specific Inspection Register” a range of:
“Business Unit” (column title & dropdown list) As in this case:
And match the relevant “Inspection Checklists” for Adelaide i.e., “AED Defib Machine” of which each checklist entered has an automated “Created Date” @ row.
· I would like to record this date to a single report sheet (A) “Adelaide Annual WHS Calendar”. specific to this item in a static row.
· Under a column titled "Last Date Inspected?” (Date Field)
I have tried a range of functions – Index / Match & Vlookup without success.
If solved this type of function will have really good outcomes for our business with multiple data being collated across many sheets, especially training records & tracking.
Help Article Resources
Check out the Formula Handbook template!