What are the differences and applications of VLOOKUP and XLOOKUP functions in Excel?

Question

Accepted Answer

VLOOKUP and XLOOKUP are Excel functions used for searching and retrieving data, with XLOOKUP being the newer and more versatile option.

VLOOKUP searches for a value in the first column of a range and returns a value in the same row from a specified column.
XLOOKUP can search in any direction (rows or columns), and can return values from a range based on multiple criteria.
XLOOKUP is more flexible and powerful than VLOOKUP, as it can handle array calculations and return multiple results.
XLOOKUP is available in newer versions of Excel, while VLOOKUP is a legacy function.
Example: VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in A2 in the range B2:D10 and returns the value in the 3rd column.
Example: XLOOKUP(A2, B2:B10, C2:C10, "Not Found", 0, 1) - searches for the value in A2 in the range B2:B10 and returns the corresponding value from C2:C10.

Top Corbus Supply Chain Executive interview questions & answers