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 ?
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: https://www.youtube.com/playlist?list=PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs
WATCH NEXT ? https://youtu.be/z-62JPTqgiw How to Automate Reports in Excel with Office Scripts
CHANNEL LINK ?
https://www.youtube.com/@SharonSmith
Visit my Channel page on YouTube to see all my videos, playlists, community posts and more!
TEMPLATES ?
Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv
Thank you for supporting my channel! ?
FREE DOWNLOADS ⬇️
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
CONNECT WITH ME ?
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearning/
Facebook: https://www.facebook.com/SharonSmithLearning
GEAR ⚙️
? Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
? Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
? Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
? Green Screen: https://amzn.to/2DnHsY2
? Camera: https://amzn.to/39KvpQA
? Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top-notch webcam)
RESOURCES ?
✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
?️ TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR
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
- Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url
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 ?
➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD
➤Create A Letterhead in Word: https://www.youtube.com/playlist?list=PLb80efKTbWuO0RyeiYB0fEb55601yL4OT
➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv
➤ Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90
➤ Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW
➤ Word Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45
#vlookup #xlookup #microsoftexcel #msexcel #dataextraction #dataretrieval