Hello, 

my input data says this. Before 01-August, the administration of City 1 was overseen & supported by State 1

After 10th-August, City 1 was supported by State2, and from date 20th-Aug onwards, it is being supported by State3. 
Like this i have many cities and corresponding states changing based on date values

How do i return the corresponding state value for a city, for that date condition ? 

i m tried this in State Column. But not working.
=XLOOKUP([@City],DATEVALUE(Table1[[#Headers],[01-Aug-24]:[20-Aug-24]])>=[@Date],Table1[[01-Aug-24]:[20-Aug-24]],””,0,1)
Need suggestions for the match logic.

Thank you
kalyan

Thank you. 

​Hello,  my input data says this. Before 01-August, the administration of City 1 was overseen & supported by State 1After 10th-August, City 1 was supported by State2, and from date 20th-Aug onwards, it is being supported by State3. Like this i have many cities and corresponding states changing based on date valuesHow do i return the corresponding state value for a city, for that date condition ? i m tried this in State Column. But not working.=XLOOKUP([@City],DATEVALUE(Table1[[#Headers],[01-Aug-24]:[20-Aug-24]])>=[@Date],Table1[[01-Aug-24]:[20-Aug-24]],””,0,1)Need suggestions for the match logic.Thank youkalyanThank you.    Read More

​