We have already looked at using XLOOKUP to return data where columns are not in a contiguous order.
There are many other uses of the XLOOKUP function. One could be to return the number of orders between two dates or the value of orders between two dates.
In the spreadsheet shown we have order dates and individual orders. Say, I wanted to find how many orders came in in July 2020.
I have added the required Start Date in cell I2 and the required Finish Date in cell J2.
The relevant combination of the functions COUNT and XLOOKUP in cell K2 would be:
Similarly, I could use the SUM function on a relevant column to find the total value of orders.
Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Somerset and Hampshire.