The values I have are minimum and maximum from a range that spans years of sales. The columns represent the years, and these are not all just numbers, they have variances and other things, so just getting the years was a bit of a challenge on itself.
After I got the minimum sales and maximum sales from across twenty-two years, I thought I could simply use xlookup to find the year and another xlookup to find the day, but it didn’t work because the range is not just one row or column, but a couple hundred.