How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP

How to pull a column of data into an Excel report from another spreadsheet using VLOOKUP and then XLOOKUP functions. Extract data from one workbook to another. You'll learn how to apply the VLOOKUP and XLOOKUP functions to your data extraction tasks. Whether you're a beginner or an advanced Excel user, this video will help you save time and reduce errors in your work. Let's compare VLOOKUP and XLOOKUP.

So, which function should you use? It really depends on your specific situation, your level of comfort in Excel, and the complexity of the task you need to accomplish. VLOOKUP is a great function for finding related information in large tables or when you want to add a column of data to a report, which is what we are going to do in this tutorial.

Syntax for VLOOKUP:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Now, VLOOKUP does have its limitations. For example, it only works to the right of the lookup value, so you can't use it to look up values to the left of the lookup column. Additionally, VLOOKUP can only search for exact matches or approximate matches based on the closest value, which can be problematic if you have duplicate values.

XLOOKUP is a more powerful function than VLOOKUP that allows you to search for values in any direction (left, right, up, or down) and also supports fuzzy matches and wildcards.

Syntax for XLOOKUP:
=XLOOKUP(lookup_value, lookup_array, return_array, [not_found], [match_mode], [search_mode])

TIMESTAMPS ⏰
00:00 Pull Data into Excel Report with VLOOKUP & XLOOKUP
00:25 How to Insert Functions in Excel
02:17 How to use VLOOKUP in Excel
03:44 How to use XLOOKUP in Excel

COURSE 🎒

CHANNEL LINK 📺
Visit my Channel page on YouTube to see all my videos, playlists, community posts and more!

TEMPLATES 📄
Thank you for supporting my channel! 🌟

FREE DOWNLOADS ⬇️

CONNECT WITH ME 📎

GEAR ⚙️

RESOURCES 📚

Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!

SUPPORT THIS CHANNEL 🙌
- Hit the "$Thanks" button on any video, or

If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️

PLAYLISTS 🎥

#vlookup #xlookup #microsoftexcel #msexcel #dataextraction #dataretrieval

[isabelleayotte]

I've never been able to actually succeed with Vlookup and XLookup, the exemples you use are so applicable to my work that it makes it easier to grasp the concept of moving data - you're videos are great! Thank you.

[davidelliott]

This is the first Excel video that after watching I successfully completed a lookup!

Thank you with yourvideo, I finally did it!!

I am so grateful for your video. You made it very simple and easy for me to understand.
I know everybody learns and understands differently, but I was beginning to think I would never get it.

I have attempted multiple times over the past year they all end in failure...sometimes i even "Break" the departments macros and databases....😱
Finally I won't have to ask the super technical office person that isn't IT but everybody asks them for help...😬

I agree with @isabellayotte having a relevant example that is comparitve to the type of work I do makes a big difference.

Thank you so much for your very intuitive and most importantly user-friendly video.

I am now a subscriber!

[anaelizabethrobledo]

This video was very helpful! Thank you so much!

[Petitecharmdiaries]

Your videos are best. No one made vlookup so easy. Thanks a lot

[mdwestmale]

THANK YOU SHARON!! I also watched several tutorials on how to use VLOOKUP as you described, and not being familiar with its use, it TOTALLY WORKED! You explained it best for me to understand and use on my own. THANK YOU! THANK YOU! THANK YOU!

[BlackRussian]

Wow!!! thank you so much!!! So clear, concise, and easy to understand.

[nicwalk]

OMG! Your videos explain very clearly how to both formulas. I have struggled for years. So keep them coming.

[samanmaeruf]

I watched a lot of tutorials... you are the best, thank you very much my dear

[selhadinabdibeker]

I have never given a comment on YouTube. you are the first. you really saved me from 3 days of work, thank you so much, tag me in your videos, I will give it a big like always.

[FredJumayao]

You are so awesome! Thanks, been meaning to learn how to use these functions, but now that I have a need I'm forced to learn it, lol. Yours was the first video I found and you explained it so clearly and succinctly.

[j.r.]

Incredibly helpful!! I will be using this today!!

[rk]

How do you handle multiple rows with the same employee? Seems Vlookup only shows the first occurrence.

[antidiuslaurian]

Thanks for the tutorial, it's very informative. But I have encountered issues on extracting columns involving dated (its writing N/A). Again sometimes it is extracting information from the wrong column I am intending to. Can I get clarification on this please?, perhaps there's something I'm doing without knowing... Thanks much.

[aditya_stackoverflow]

suppose the work email is also missing and if we want to get the work email by dragging the same formula to the right, what will be the process? please tell

[JabbaRankz_]

Im having issues anchoring can you do i video please