How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
HTML-код
- Опубликовано: 9 июн 2024
- 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: • Creating Fillable Form...
WATCH NEXT 📺 • Automate Reports in Ex... How to Automate Reports in Excel with Office Scripts
CHANNEL LINK 📺
/ @sharonsmith
Visit my Channel page on RUclips to see all my videos, playlists, community posts and more!
TEMPLATES 📄
Check out my helpful list of templates available for purchase: creatoriq.cc/43c51cv
Thank you for supporting my channel! 🌟
FREE DOWNLOADS ⬇️
✦ Visit mailchi.mp/6a0859ea0844/sharo... 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: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
Instagram: / sharonsmithlearning
Facebook: / sharonsmithlearning
GEAR ⚙️
🎙 Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: techsmith.z6rjha.net/NZG5b
📗 Green Screen: amzn.to/2DnHsY2
📸 Camera: amzn.to/39KvpQA
🔌 Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top-notch webcam)
RESOURCES 📚
✏️ JotForm: www.jotform.com/pricing/?utm_...
🖥️ TechSmith Camtasia Screen Recording: techsmith.z6rjha.net/SharonSm...
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: www.paypal.com/cgi-bin/webscr...
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: • Jotform Tutorials
➤Create A Letterhead in Word: • Create A Letterhead in...
➤Creating Fillable Forms: • How To Create A Fillab...
➤ Excel Tutorials: • Microsoft Excel Tutorials
➤ Excel Tips & Tricks: • Excel Tips & Tricks
➤ Word Tutorials: • Microsoft Word Tutorials
#vlookup #xlookup #microsoftexcel #msexcel #dataextraction #dataretrieval
OMG! Your videos explain very clearly how to both formulas. I have struggled for years. So keep them coming.
So glad you found my videos helpful! Thanks for watching!
I have never given a comment on RUclips. 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.
Thanks so much for your nice comment! I'm so glad you found my videos helpful. Thanks for watching! Best of luck to you!
Incredibly helpful!! I will be using this today!!
That is great to hear! Thanks for watching!
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
Im having issues anchoring can you do i video please