In this video I have explained Excel Xlookup Function. Xlookup function is an alternative of Vlookup or Index Match functions. You will learn how to use Xlookup function and what it can do for you.
Protect your Excel Sheet with Password
[ Ссылка ]
Quick Way to Change Text Case
[ Ссылка ]
Excel Advance Filter
[ Ссылка ]
Visit our Website to Learn more about Excel Functions
[ Ссылка ]
What Xlookup can do for you?
Unlike Vlookup, Xlookup can lookup values from right or left both sides of table
Xlookup can lookup horizontally and vertically
Xlookup can lookup for next smallest and largest values
By Default, Xlookup looks for an exact match but it can be changed if you would like to change
![](https://i.ytimg.com/vi/OjuHzU-l3P4/maxresdefault.jpg)