Standard Lookups: XLOOKUP can be used as a replacement for the traditional VLOOKUP and HLOOKUP functions to perform standard vertical or horizontal lookups.