Spreadsheet: 696105d1600628964-looking-up-by-multiple-criteria-the-last-date-an-event-occurred-lookup
Sheet: data

Site | Month | Month1 | Year | Type | event |  | Criteria
site1 | January | 1 | 2015 | type1 | 0 |  | site | site1
site2 | January | 1 | 2015 | type1 | 0 |  | type | type1
site1 | February | 2 | 2015 | [NAME] | 0 |  | event | <>0
site2 | February | 2 | 2015 | type1 | 2 |  | last event | "August"-2020
site1 | March | 3 | 2015 | [NAME] | 1 |  | first event | "June"-2015
site1 | April | 4 | 2015 | type1 | 0
site1 | June | 6 | 2015 | type1 | 1
site1 | June | 6 | 2015 | [NAME] | 1
site2 | June | 6 | 2015 | [NAME] | 0
site2 | July | 7 | 2015 | [NAME] | 1
site1 | August | 8 | 2015 | type1 | 1
site2 | August | 8 | 2015 | type1 | 2
site2 | September | 9 | 2015 | [NAME] | 1
site1 | October | 10 | 2015 | type1 | 2
site2 | October | 10 | 2015 | type1 | 3
site2 | October | 10 | 2015 | [NAME] | 1
site1 | November | 11 | 2015 | [NAME] | 1
site2 | November | 11 | 2015 | [NAME] | 2
site2 | December | 12 | 2015 | type1 | 0
site2 | December | 12 | 2015 | [NAME] | 1
site2 | January | 1 | 2016 | type1 | 1
site2 | January | 1 | 2016 | [NAME] | 1
site2 | February | 2 | 2016 | [NAME] | 2
site1 | March | 3 | 2016 | type1 | 1
site1 | March | 3 | 2016 | [NAME] | 1
site2 | March | 3 | 2016 | type1 | 1
site2 | March | 3 | 2016 | [NAME] | 0
site2 | April | 4 | 2016 | type1 | 2
site1 | May | 5 | 2016 | type1 | 1
site2 | June | 6 | 2016 | type1 | 0
site2 | June | 6 | 2016 | [NAME] | 2
site1 | July | 7 | 2016 | [NAME] | 0
site2 | July | 7 | 2016 | type1 | 1
site2 | July | 7 | 2016 | [NAME] | 1
site1 | August | 8 | 2016 | type1 | 1
site2 | August | 8 | 2016 | type1 | 2
site2 | September | 9 | 2016 | type1 | 1
site2 | September | 9 | 2016 | [NAME] | 1
site2 | October | 10 | 2016 | [NAME] | 1
site2 | November | 11 | 2016 | [NAME] | 0
site1 | December | 12 | 2016 | type1 | 0
site2 | December | 12 | 2016 | type1 | 2
site2 | December | 12 | 2016 | [NAME] | 1
site1 | January | 1 | 2017 | type1 | 1
site1 | January | 1 | 2017 | [NAME] | 1
site1 | February | 2 | 2017 | type1 | 1
site2 | February | 2 | 2017 | [NAME] | 1
site2 | May | 5 | 2017 | type1 | 0
site2 | June | 6 | 2017 | [NAME] | 2
site1 | July | 7 | 2017 | type1 | 1
site1 | August | 8 | 2017 | type1 | 2
site1 | August | 8 | 2017 | [NAME] | 0
site2 | August | 8 | 2017 | type1 | 3
site2 | August | 8 | 2017 | [NAME] | 1
site1 | September | 9 | 2017 | [NAME] | 1
site2 | September | 9 | 2017 | type1 | 6
site2 | September | 9 | 2017 | [NAME] | 1
site1 | October | 10 | 2017 | type1 | 0
site2 | October | 10 | 2017 | [NAME] | 1
site2 | November | 11 | 2017 | type1 | 1
site2 | December | 12 | 2017 | type1 | 1
site2 | January | 1 | 2018 | type1 | 3
site2 | January | 1 | 2018 | [NAME] | 2
site1 | February | 2 | 2018 | type1 | 1
site1 | March | 3 | 2018 | type1 | 0
site2 | March | 3 | 2018 | type1 | 2
site2 | April | 4 | 2018 | type1 | 2
site2 | April | 4 | 2018 | [NAME] | 3
site1 | May | 5 | 2018 | type1 | 1
site1 | June | 6 | 2018 | type1 | 1
site2 | June | 6 | 2018 | [NAME] | 1
site1 | July | 7 | 2018 | type1 | 1
site1 | July | 7 | 2018 | [NAME] | 2
site2 | July | 7 | 2018 | type1 | 2
site2 | July | 7 | 2018 | [NAME] | 2
site2 | August | 8 | 2018 | type1 | 1
site2 | August | 8 | 2018 | [NAME] | 2
site1 | September | 9 | 2018 | type1 | 1
site1 | October | 10 | 2018 | type1 | 1
site2 | October | 10 | 2018 | type1 | 2
site1 | November | 11 | 2018 | [NAME] | 2
site2 | November | 11 | 2018 | type1 | 2
site1 | December | 12 | 2018 | [NAME] | 1
site2 | December | 12 | 2018 | type1 | 1
site2 | December | 12 | 2018 | [NAME] | 1
site2 | February | 2 | 2019 | type1 | 2
site1 | March | 3 | 2019 | type1 | 1
site2 | March | 3 | 2019 | type1 | 1
site1 | April | 4 | 2019 | type1 | 1
site1 | May | 5 | 2019 | type1 | 2
site2 | June | 6 | 2019 | type1 | 3
site1 | July | 7 | 2019 | type1 | 1
site2 | July | 7 | 2019 | type1 | 1
site2 | August | 8 | 2019 | type1 | 1
site1 | September | 9 | 2019 | type1 | 1
site2 | November | 11 | 2019 | type1 | 1
site2 | November | 11 | 2019 | [NAME] | 1
site1 | January | 1 | 2020 | type1 | 1
site1 | January | 1 | 2020 | [NAME] | 1
site2 | January | 1 | 2020 | type1 | 1
site1 | February | 2 | 2020 | type1 | 1
site2 | March | 3 | 2020 | type1 | 1
site2 | March | 3 | 2020 | [NAME] | 1
site2 | June | 6 | 2020 | type1 | 2
site1 | August | 8 | 2020 | type1 | 1
site2 | August | 8 | 2020 | type1 | 2
site2 | August | 8 | 2020 | [NAME] | 1