Forum Discussion
I need to return a value corresponding to date
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-...
As variant
=INDEX( XLOOKUP([@Date], 1*DROP(Source[#Headers],,1),DROP(Source,,1),,-1), XMATCH([@City],Source[City] ) )
As variant
=INDEX( XLOOKUP([@Date], 1*DROP(Source[#Headers],,1),DROP(Source,,1),,-1),
XMATCH([@City],Source[City] ) )
Works like Magic. Thank you.
KalyanPrasad , you are welcome
