INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works ...

We're about to hit that very confusing time of year, when summer starts to meet fall, and the weather is as indecisive as we are. You can wake up to a warm sunny day, followed by a chilly afternoon.