XLOOKUP

Learn what lookup functions do, why VLOOKUP searches the first column, and how copied ranges and column positions affect its results.