16 Ara 2019 ... XLOOKUP can look to its left, defaults to an exact match, and allows you to specify a range of cells instead of a column number.