Match and Index functions to create a table referencing another sheet

Hello,

I need help creating a formula which will work.

Sheet 1 - contains my data


Sheet 2 - Contains the tracking matrix I am trying to create


I need a formula which will look at sheet 1, determine if an inspection has taken place within a certain month, and then return the date of that inspection into sheet 2.


I've been told to use INDEX or MATCH formulas, but have no idea how that would be constructed.


Help greatly appreciated 😀

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!