Using XLOOKUP for One-Way Lookups in Excel The key to understanding how XLOOKUP can be used to perform two-way lookups is to first get your head around how this function works in one-dimensional ...