XLOOKUP Vs. VLOOKUP: 🥊🔔
Both XLOOKUP and VLOOKUP are lookup functions used to ‘lookup’ a value from a data table and then return corresponding values. So you might be asking yourself how they work and which one is better?
How VLOOKUP Works:
The VLOOKUP function performs a vertical lookup by searching for the lookup_value from the top of the first column in the table_array and returns a corresponding value to the right based on the col_index_num.
The VLOOKUP function performs a vertical lookup by searching for the lookup_value from the top of the first column in the table_array and returns a corresponding value to the right based on the col_index_num.
How XLOOKUP Works:
XLOOKUP allows you to look up information in a data table by searching for the lookup_value in the lookup_array and then returning the corresponding value in the return_array.
XLOOKUP allows you to look up information in a data table by searching for the lookup_value in the lookup_array and then returning the corresponding value in the return_array.
XLOOKUP is the modern successor of VLOOKUP. It offers more flexibility, improved search features, and can assign default values. But most importantly, XLOOKUP can return values from any direction from the lookup_value while VLOOKUP can only return values to the right.
Here's a full breakdown of the differences: 
Hopefully now you know which lookup function to use next time...
Follow me @exceldictionary for even more Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com/collections/ex…
Follow me @exceldictionary for even more Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com/collections/ex…
• • •
Missing some Tweet in this thread? You can try to
force a refresh
