How to use the XLOOKUP function in Excel

0:32 - VERTICAL lookup example
2:21 - HORIZONTAL lookup example

Learn how to use the XLOOKUP function which is the next generation lookup function in Microsoft Excel. The XLOOKUP function has the functionality of both the VLOOKUP as well as the HLOOKUP functions, without the limitations.

This tutorial demonstrates how to use Excel XLOOKUP with our easy to follow examples and takes you through how to perform a vertical lookup as well as a horizontal lookup.

XLOOKUP Function (and sample data):

How to use the VLOOKUP function in Excel:

How to use the HLOOKUP function in Excel:

Excel Functions/Formulas:

Excel Tutorials:

Don't forget to subscribe to our channel for more great Excel tutorials!

or follow us on:

[shreshthsanjay]

This channel has very few videos but is literally a gem!! Please make more videos on excel or any related tools
Your tutorials are very precise and great! ❤

[LaToyaParker-fwtv]

Definitely the best videos in my opinion explaining XLOOKUP and HLOOKUP. All the others I watched was really confusing. you made it really simple and easy to understand! Thank you so much! Have you made a video on HLOOKUP approximation?

[daniellenunes]

This video helped me the most. I watched so many videos and didn't get it. Now I do!

[dravyamsekhsaria]

Couldnt understand sumif, and the lookups. But when i saw one of ur videos i understood u r the best. Thank You. Tomorrow i have exam

[saranj]

i love all your excel tutorial. ♥️♥️♥️

[jaganmohan]

very help full. and easy to understand . please share the updated video for other option also

[dhrubasardar]

This channel is great👍👍👍👏👏👏.... Really

[victorbassey]

m=Thanks, but mine didn't return. Is Xlookup a new formula, as excel did not populate it?

[heidi-hutv]

Do you have a video on filtering and sorting?

[dalebrooks]

I just can’t get this to work #VALUE everytime!