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

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