XLookup Row Column Match Excel

This video shows how to nest the XLookup Function within another XLookup for a Row and Column Lookup within a set of data. This illustration displays how the XLOOKUP Function has the ability to search vertically and horizontally simultaneously on a grid of data. Please keep in mind that the XLookup function is only available in Office 365 subscriptions.
You can download a copy of this workbook at the link below:
theexcelcave.weebly.com/xlook...