Difference between Vlookup and xlookup?

Question

Accepted Answer

Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible version of Vlookup.

Vlookup searches vertically in a table for a value and returns a corresponding value from a specified column.
Xlookup can search both vertically and horizontally in a table, and can return values from any column or row.
Vlookup requires the lookup value to be in the first column of the table, while Xlookup allows for more flexibility in choosing the lookup and return columns.
Xlookup can handle array calculations and return multiple values, while Vlookup can only return a single value.
Xlookup is available in newer versions of Excel, while Vlookup is a more traditional function.

Difference between Vlookup and xlookup?

Top Apsis Technologies MIS Executive and Analyst interview questions & answers

Popular interview questions of MIS Executive and Analyst