XLOOKUP Horizontal Lookup

Originally published at: Excel XLOOKUP Horizontal Lookup - Excelbuddy.com

Learn to perform a horizontal lookup using XLOOKUP. With XLOOKUP, you no longer have to use the very limited HLOOKUP function. In the example below, we will perform a lookup with an Exact match and an Approximate Match. Let’s take a look at the following example. Here, we are using a horizontal lookup to return…