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 STARTXLOOKUP RANGE FINISH