Using XLOOKUP to Reference a Cell Range

In this video we show how XLOOKUP can be used to reference a range of cells in a table based on the start and end row (or column) chosen. 

These are the two files needed to follow along to this video:

XLOOKUP RANGE START

XLOOKUP RANGE FINISH