Excel Xlookup Explained in 2 Minutes | How to Use Excel Xlookup Function

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
• Excel Xlookup Explaine...
Quick Way to Change Text Case
• Quick Way To Change Te...
Excel Advance Filter
• Excel Advance Filter |...
Visit our Website to Learn more about Excel Functions
alichaudary.com
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

[@athirahzainudin1441]

Hi, I cant get xlookup fx also..its appear like this Sheet1!A3:A10,Sheet1!B3:E10

[@neiljohntolentino6365]

Sir, after i did xlookup for the name it didnt work, what happened is #name?

[@ooogress2117]

Couldn't get xlookup function

[@LearnforFuture]

Xlookup is only available in MS Office 365

[@ManliestofMen]

Send us your template

[@ManliestofMen]

Send us your template

[@henryjohn9748]

The video is not clear its too blurry

[@LearnforFuture]

It’s clear, try checking your video resolution settings