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

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

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

athirahzainudin
Автор

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

neiljohntolentino