Match Names on Two Excel Sheets with VLOOKUP – Create Unique ID in Excel

How to match and compare names from two different Excel spreadsheets using VLOOKUP // In this example, we have a master spreadsheet of employee names and then a tracking spreadsheet with the employee names who have completed a task and we want to match the names on the master spreadsheet so we can see who still needs to complete the task. We use VLOOKUP and column filters to accomplish this. Then we look at how to create a column of unique identifiers if one does not already exist on both sheets, so we can use VLOOKUP. To do this, we use Text to Columns and also the Concat formula.

🚀 Take your form-building skills to the next level with my Course on Creating Fillable Forms in Microsoft Word:
https://www.youtube.com/playlist?list=PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs

▶ Watch Next - VLOOKUP Tutorial: https://youtu.be/Xb_RGYYKbRk
__________
RESOURCES & 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)
✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=

Some 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!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this 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
__________
KEYWORDS: #MSExcel, how to match names in Excel, how to compare names from two sheets in Excel, VLOOKUP, CONCAT, Text to Columns, how to compare list of names from two sheets, Excel formulas for HR, Excel tips and tricks, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD

➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR

Тэги:

#excel_tutorials #advanced_excel_tricks #excel_tips_and_tricks #excel_tips #how_to #learn_excel #excel_tutorial_formulas #excel_tutorial #vlookup_in_excel #text_to_columns_in_excel #concatenate_excel #match_names_in_two_excel_sheets #match_names_in_excel #match_names_between_two_spreadsheets #match_names_in_excel_formula #compare_names_in_two_excel_sheets

Скачать видео