XLOOKUP vs VLOOKUP in Excel - What's the Difference?

The XLOOKUP and VLOOKUP functions in Excel are used to find, or 'lookup', a value from a table or a list and then return a related result.

In this video, we’ll discuss XLOOKUP vs VLOOKUP with examples of how to use each.

Skip to:
0:00 - Introduction
1:18 - VLOOKUP 
2:32 - XLOOKUP

——

#XLOOKUPvsVLOOKUP #MSExcel #ExcelTutorial

——

——

For more updates follow us on:

——
Video content by Lydia Uys, and presented by Dan Gorgone for GoSkills

[CTDisciples]

Hands down one of the best excel tutorials I have seen and I have seen too much

[mikeydan]

I know this was three years ago, but... this REALLY helped. I have watched (too) many vids on VLookups with much, much frustration. I was recently told about XLookups and wanted to know the difference between them... this was super helpful and was presented in a manner I could actually understand. I am not an Excel fan, but I have to use it. My brain is not wired to grasp this stuff easily. I will definitely go back to this vid and check out the others. Thank you!

[RameeJordan]

Thank you! Your tutorial was very simple, to the point, and easy to follow.

[fredwhitehouse]

Best video on xlookup on youtube. Well done.

[basilchuti]

Simple explanation and to the point. Thank you

[bobsagget]

Sorry Vlookup, Xlookup is my new best friend

[mambofornasa]

You are a King!!! The explanations are clear and concise. Very grateful I found this channel.

[rupertrussell]

Fantastic Video, I love the way you highlighted the results in green, One thing I often do is search for data on another worksheet which you can do easily just put the name of the worksheet followed by an exclamation mark! and then the lookup range eg: =XLOOKUP(A2, placements!A:A, placements!B:B, "Unknown") In this example the worksheet I am looking at is called placements

[md.sakerurrahmanauntor]

Thank you so much for giving such a nice differentiated video between the two essential formulas. I think, Vlookup is about to RIP now.

[tidy]

EXCELLENT Everything is well explained and slow step by step instructions!

[helenamouton]

This is so nice. can't believe I was still doing ISNA and VLOOKUP for the past three years🙈

[FredyVergara]

excellent ill use this for my reports. thanks!!

[AlejoBri-vfjs]

Thank you!! You made it nice and simple and most important quick!!

[VincentGB]

Very clear and precise explanation. Thank you!

[discoverwithtwins]

Great Informative Video.. Thanks For sharing

[Thorin]

Amazing! Just an amazing explanation. Thank you, Sir.

[somyajain]

In return array what to do if my columns are not together from where I am selecting. Like there are other columns in between them. So what do I need to type or how should I select.

[divyarepalle]

very clear explanation. I have a question, I am able to get the first name last name at a time as you explained but when I tried to apply it to other cells I am unable to do it like how we drag or double click.please help me

[joypid]

Thanks, will like to know about excel.

[nangiasharad]

Amazing explanation, however Need more complex examples in xlookup .. also vlookup only searches for data on the right and not left .. should have been emphasized more when speaking about advantages about xlookup and this is one of the key differentiating factor between xlookup and vlookup