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

CarlosF

Brass Contributor

Feb 26, 2022

harshulz AmyYang

I really doen't undestard this formulae.

If you fill the table1 for Argentina and date 01/03/2022 with "100%", the result of the formulae will not be the latest value different to 0, it will be the biggest one, which, in this case, will be 100%..

Sorry if I am wrong.

Regards,

Carlos

Forum Discussion

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

Resources