Forum Discussion

AmyYang's avatar
AmyYang
Brass Contributor
Feb 20, 2022
Solved

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...
excel
CarlosF's avatar
CarlosF
Brass Contributor
Feb 20, 2022

Hi AmyYang

 

This work for me. In cell B6 (Chile) or whatever cell in column B you can try:

 

 

= XLOOKUP(
	$A6&MAX(
		FILTER(
			Table1[date],
			(Table1[location]=$A6)*
			(Table1[people_fully_vaccinated_per_hundred]>0),
			 "")
		),
	Table1[location]&Table1[date],
	Table1[people_fully_vaccinated_per_hundred],
        "No")

 

 

Best regards,

 

Carlos

Resources