How to use XLOOKUP in scenario where I want the latest date with AVAILABLE data?

Hello, May I ask, if you could open the attached excel, currently I am trying to use XLOOKUP formula to look up for example, country Chile's latest vaccination percentage from the LATEST date wi...

XLOOKUP Help - Vaccination %, next available date_20Feb.xlsx555 KB

excel

harshulz
Feb 20, 2022
AmyYang
check this out
=MAX(FILTER(Table1[people_fully_vaccinated_per_hundred],Table1[location]=Sheet1!A6,""))
XLOOKUP Help - Vaccination %, next available date_20Feb.xlsx479 KB

harshulz

Iron Contributor

Feb 20, 2022

AmyYang
check this out
=MAX(FILTER(Table1[people_fully_vaccinated_per_hundred],Table1[location]=Sheet1!A6,""))

XLOOKUP Help - Vaccination %, next available date_20Feb.xlsx479 KB

AmyYang

Brass Contributor

Feb 26, 2022

harshulz Hi Harshulz, wow, that is really great simplistic formula (which I didn't know how to use previously) ! Thank you!

Forum Discussion

How to use XLOOKUP in scenario where I want the latest date with AVAILABLE data?

Resources