The column index number is the column in the table array from which to retrieve the value, starting with 1 for the first column.

No Need to Count Columns One key difference between VLOOKUP and XLOOKUP is that the former requires me to specify a column index number where the result will be found, whereas the latter doesn't.