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

Рет қаралды 93,234

Күн бұрын

Download your free practice Excel file for this video: www.goskills.com/Excel/Resour...
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
--
Learn more with the full Excel course on GoSkills: www.goskills.com/Course/Excel...
#XLOOKUPvsVLOOKUP #MSExcel #ExcelTutorial
--
Subscribe to our KZfaq Channel for more tutorials and webinars: / @goskillscourses
--
For more updates follow us on:
- Facebook: / goskills
- LinkedIn: / 3053820
- Twitter: / getgoskills
- Instagram: / goskills
- Website: www.goskills.com/?...
--
Video content by Lydia Uys, and presented by Dan Gorgone for GoSkills

Пікірлер: 79

@CTDisciples 3 жыл бұрын

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

@GoSkillsCourses 3 жыл бұрын

Glad you think so!

@AlejoBri-vf9js Жыл бұрын

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

@lisagreghi_bookish Жыл бұрын

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

@cassandramccutcheon1703 Жыл бұрын

Thanks, Dan. Very valuable!

@fredwhitehouse879 Жыл бұрын

Best video on xlookup on youtube. Well done.

@robh5695 Ай бұрын

Excellent tutorial! Thanks Dan!

@discoverwithtwins3175 Жыл бұрын

Great Informative Video.. Thanks For sharing

@FredyVergaraShow 2 жыл бұрын

excellent ill use this for my reports. thanks!!

@malidav5724 2 жыл бұрын

Thank you great short comparison.

@GoSkillsCourses 2 жыл бұрын

You're so welcome!

@aniketjain6099 5 ай бұрын

Very well explained

@basilchuti 9 ай бұрын

Simple explanation and to the point. Thank you

@GoSkillsCourses 9 ай бұрын

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

@chanelxixixi937 2 жыл бұрын

Really helpful! Thank you.

@GoSkillsCourses 2 жыл бұрын

Glad it was helpful!

@miluskaberrocal8264 8 ай бұрын

Excellent explanation. Thanks!!!

@GoSkillsCourses 8 ай бұрын

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

@tidy Жыл бұрын

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

@abdullaponmundam5851 2 жыл бұрын

excellent, thank you

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

@CCAFO Жыл бұрын

Thank you so much!

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

@footloose72 3 жыл бұрын

Great Job, thank you

@GoSkillsCourses 3 жыл бұрын

Happy to help!

@RihanBaig 3 жыл бұрын

Great! Thanks!

@mambofornasa 2 жыл бұрын

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

@GoSkillsCourses 2 жыл бұрын

I appreciate that!

@Santhoshkumar-yp5ct 2 жыл бұрын

Great explanation

@GoSkillsCourses 2 жыл бұрын

Thank you, Santhosh!

@rodneychan1227 3 жыл бұрын

Clear and concise! Thanks!

@GoSkillsCourses 3 жыл бұрын

Happy to hear that, Rodney!

@turatskiigaming5866 Жыл бұрын

Yo this helped me alot

@billytubes 6 ай бұрын

great teacher

@anshulagarwal7069 2 жыл бұрын

very good explanation

@GoSkillsCourses 2 жыл бұрын

Thanks Anshul! Glad you liked it!

@helenamouton2856 8 ай бұрын

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

@GoSkillsCourses 8 ай бұрын

😂 XLOOKUP certainly is a game-changer, Helena!

@yashlokhande2859 3 жыл бұрын

Clear, short and crisp

@michaelmorgan4377 3 жыл бұрын

Very helpful, Dan. Thank you.

@GoSkillsCourses 3 жыл бұрын

Glad it was helpful!

@monkisethojane2218 2 жыл бұрын

thanx for the video

@GoSkillsCourses 2 жыл бұрын

Our pleasure!

@rupertrussell1 2 жыл бұрын

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 2 жыл бұрын

Correct, Rupert. Glad it was useful!

@VincentGB 2 жыл бұрын

Very clear and precise explanation. Thank you!

@GoSkillsCourses 2 жыл бұрын

You're welcome!

@joypid Жыл бұрын

Thanks ,will like to know about excel.

@GoSkillsCourses 11 ай бұрын

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 support@goskills.com

@Thorin632 Жыл бұрын

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

@bobsagget9212 2 жыл бұрын

Sorry Vlookup, Xlookup is my new best friend

@israelmello2203 Жыл бұрын

Nice video

@GoSkillsCourses Жыл бұрын

Happy to help!

@george27103 Жыл бұрын

Superb

@Meisterio 9 күн бұрын

Does X work faster than INDEX+MATCH?

@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: kzfaq.info/get/bejne/eMqffsmctJaxiZs.html

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

@maheshreddy8856 3 жыл бұрын

@pinkygupta5627 Жыл бұрын

Describe techniques are good.

@somyajain3431 7 ай бұрын

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 7 ай бұрын

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!

@shafiquemohammod 2 жыл бұрын

Gr8

@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 kzfaq.info/get/bejne/eMqffsmctJaxiZs.html 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 kzfaq.info/get/bejne/qJObhNeqsNeacWg.html

@TyVanTran Жыл бұрын

greatly

@bongflamingo3043 3 жыл бұрын

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

@GoSkillsCourses 3 жыл бұрын

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.

@ubaidillahmuhammad20 3 жыл бұрын

nice. put excel file link in the description

@GoSkillsCourses 3 жыл бұрын

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

@nangiasharad 7 ай бұрын

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 5 ай бұрын

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: kzfaq.info/get/bejne/hb5pfLti0qilnmw.html Challenge 24: kzfaq.info/get/bejne/o9WjY7F-3JnOlYE.html Enjoy!

@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: kzfaq.info/get/bejne/qJObhNeqsNeacWg.html