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

[@CTDisciples]

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

[@GoSkillsCourses]

Glad you think so!

[@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!

[@GoSkillsCourses]

It's a classic! We're glad to know it has been useful for you since then! 🌟

[@bobsagget9212]

Sorry Vlookup, Xlookup is my new best friend

[@yashlokhande2859]

Clear, short and crisp

[@basilchuti]

Simple explanation and to the point. Thank you

[@GoSkillsCourses]

Thank you for the review, Basil! We're glad to hear this tutorial has been useful!

[@fredwhitehouse879]

Best video on xlookup on youtube. Well done.

[@md.sakerurrahmanauntor1389]

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

[@RameeJordan]

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

[@GoSkillsCourses]

Thank you so much! We're thrilled to hear that you found the tutorial simple and easy to follow. 😊 Your feedback means a lot to us!

[@mambofornasa]

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

[@GoSkillsCourses]

I appreciate that!

[@helenamouton2856]

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

[@GoSkillsCourses]

😂 XLOOKUP certainly is a game-changer, Helena!

[@robh5695]

Excellent tutorial! Thanks Dan!

[@samplaying4keeps]

This was super helpful. Thank you!

[@malidav5724]

Thank you great short comparison.

[@GoSkillsCourses]

You're so welcome!

[@VincentGB]

Very clear and precise explanation. Thank you!

[@GoSkillsCourses]

You're welcome!

[@FredyVergara]

excellent ill use this for my reports. thanks!!

[@rupertrussell1]

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

[@GoSkillsCourses]

Correct, Rupert. Glad it was useful!

[@tidy]

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

[@Santhoshkumar-yp5ct]

Great explanation

[@GoSkillsCourses]

Thank you, Santhosh!

[@CCAFO]

Thank you so much!

[@footloose72]

Great Job, thank you

[@GoSkillsCourses]

Happy to help!

[@AlejoBri-vf9js]

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

[@aniketjain6099]

Very well explained

[@cassandramccutcheon1703]

Thanks, Dan. Very valuable!

[@rodneychan1227]

Clear and concise! Thanks!

[@GoSkillsCourses]

Happy to hear that, Rodney!

[@miluskaberrocal8264]

Excellent explanation. Thanks!!!

[@GoSkillsCourses]

Thank you, Miluska! 🙌 We're glad you found it helpful!

[@anshulagarwal7069]

very good explanation

[@GoSkillsCourses]

Thanks Anshul! Glad you liked it!

[@discoverwithtwins3175]

Great Informative Video.. Thanks For sharing

[@turatskiigaming5866]

Yo this helped me alot

[@billytubes]

great teacher

[@RihanBaig]

Great! Thanks!

[@monkisethojane2218]

thanx for the video

[@GoSkillsCourses]

Our pleasure!

[@chanelxixixi937]

Really helpful! Thank you.

[@GoSkillsCourses]

Glad it was helpful!

[@Thorin632]

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

[@michaelmorgan4377]

Very helpful, Dan. Thank you.

[@GoSkillsCourses]

Glad it was helpful!

[@joypid]

Thanks ,will like to know about excel.

[@GoSkillsCourses]

hi @joypid, are you new to Excel? We have a free crash course here: www.goskills.com/Course/Learn-Excel-Tutorial/About If you want to do the Basic to Advanced certification, check it out here: www.goskills.com/Course/Excel/About Contact our Support team if you have any questions! Email them at [e-mail]

[@israelmello2203]

Nice video

[@GoSkillsCourses]

Happy to help!

[@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

[@GoSkillsCourses]

Hi @nangiasharad, that's right! Lookup in any direction is definitely one of the biggest advantages of XLOOKUP. The full list is summarized in the article linked in the video description www.goskills.com/Excel/Resources/Xlookup-vs-vlookup. For a more challenging workout, try these Excel challenges featuring XLOOKUP and compare your solution to ours. Challenge 7: kzbin.info/www/bejne/hYmceotnoqd0pJo Challenge 24: kzbin.info/www/bejne/o6DWYYGDrJidm68 Enjoy!

[@somyajain3431]

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.

[@GoSkillsCourses]

Hi @somyajain3431, if you want to return multiple columns using XLOOKUP, those columns must all be adjacent (next to each other). If you want to return values from more than one column but those columns are not adjacent, you might consider using FILTER nested within FILTER. You can take a look under the subheading "Example 4 - FILTER and FILTER" in the following article for how this can be done: www.goskills.com/Excel/Resources/Excel-dynamic-arrays. Hope this helps!

[@george27103]

Superb

[@pinkygupta5627]

Describe techniques are good.

[@divyarepalle678]

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

[@GoSkillsCourses]

Hello Divya, you can copy the formula in the usual way - by dragging or double-clicking on the fill handle. But to make sure that your range stays the same, use absolute cell referencing like this: =XLOOKUP(A6,$J$4:$J$14,$K$4:$K$14) before you copy. You're just putting dollar signs before each reference. Learn more about absolute cell referencing here: kzbin.info/www/bejne/eJXSfJmhhJWAj8k

[@Meisterio]

Does X work faster than INDEX+MATCH?

[@lydiauys3106]

Yes, much and it has a "built in" iferror.

[@maheshreddy8856]

Tq

[@TyVanTran]

greatly

[@ubaidillahmuhammad20]

nice. put excel file link in the description

[@GoSkillsCourses]

Hi Ubaidillah, you can find the file download in this article: www.goskills.com/Excel/Resources/Xlookup-vs-vlookup

[@leroyholt77]

Nice, but when I try and copy the formula to other cells it changes the cell lookup range. How do you lock this field?

[@GoSkillsCourses]

Hi Leroy, you can lock the range (make it an absolute reference) by inserting "$" before the row and the column of the reference. E.g. A2:A12 would become $A$4:$A$12. See our video kzbin.info/www/bejne/eJXSfJmhhJWAj8k for an explanation and shortcuts to using this feature. Otherwise, you could just turn your dataset into a Table and not have to worry about that at all kzbin.info/www/bejne/qF7OgqevgNZpd5Y

[@moesadr3342]

Thanks for all amazing training videos, short, sweet and right to the point but very through! Would you kindly let me know how I can use XLOOKUP up to search for the number of rows with a field includes certain value for This and/ or Last Week, This and/ or Last Month, This and/ or Last Quarter and This and/ or Last Year? ( The first column in my worksheet is a Created Date and I would like to compare the created rows for different categories based on above mentioned time periods, last month's quote, orders, invoiced,.....) How would the formula could look? Do you know a better solution without NO VBA? Thank you!

[@GoSkillsCourses]

Hello Moe Sadr, we're glad you found the video helpful! To better understand and answer your question, could you please share a sample of your worksheet and what you would like it to do by joining our Slack channel here: goskills.typeform.com/to/h0GBH4oe. See you there!

[@aphricanlenss]

Hi, I have a question. I am using VLOOKUP to insert information to a new sheet. Now, I would like it to be done automatically after the input is written. Any ideas to solve this?

[@aphricanlenss]

For example; cell A4 is written then the rest fill out based on the previous functions written instead of continuing to drag down

[@GoSkillsCourses]

Hi @@aphricanlenss , you can format your data as a table and new rows will be populated with the formulas automatically. Hope this helps!

[@GoSkillsCourses]

You might want to check out this video: kzbin.info/www/bejne/qF7OgqevgNZpd5Y

[@bongflamingo3043]

Do I still need to use absolute reference '$' in xlookup?

[@GoSkillsCourses]

Hi Emmanuel! The purpose of $ doesn't change. It is used to "lock" or fix references to a cell, so yes you would still use $ to make a reference absolute. If you don't like using $ to refer to a range, you can convert your data set to an Excel table.

[@M3_86]

Index match match still the best lol

[@lisagreghi_bookish]

You helped me solve the formula, thank you so much!

[@abdullaponmundam5851]

excellent, thank you