Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets

In this step-by-step tutorial, learn to use the MATCH function in Excel to find and match multiple values from two sheets. Once we compare two lists in Excel, we use special conditional formatting formulas to highlight matches. In this video we have a small list of employees in Excel and we want to search for those employees in a larger employee database and when we find a matching employee, we want to highlight the entire row.

The MATCH function will lookup a value from an array on a different sheet and return the number of the row on that sheet where it finds a match. We then wrap the MATCH formula inside ISNUMBER to return either TRUE or FALSE. From there, we can apply a conditional formatting formula to search for "TRUE" and highlight the entire row by using Search and then concatenating the rows you want to highlight. The conditional formatting formula we use in this video is:
=SEARCH("TRUE",$A2&$B2&$C2&$D2&$E2&$F2&$G2)

Next we look at how to use filters to manually highlight the spreadsheet as a way to search and highlight in Excel.

📺 Watch Next - Match Names in 2 Sheets with VLOOKUP: https://youtu.be/_2HODd8Gq3A

FREE COURSE 🎓:
How To Create Fillable Forms in Microsoft Word - A Step-by-Step Guide
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro!
https://youtu.be/438pCPCSuG4

__________
TIMESTAMPS ⏰
00:00 Find Matching Employees in Excel
00:20 Match Names from Two Sheets
01:00 How to Match Values in Excel
03:15 MATCH Overview
04:00 ISNUMBER Overview
05:00 Conditional Formatting to Highlight Row
08:50 Filter and Highlight Matches in Excel
__________
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
__________
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
📑 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.
__________
KEYWORDS: #msexcel, @SharonSmith
Find, Match, and Highlight Names from Two Sheets in Excel, Find Matching Values in Two Worksheets, Compare Two Lists in Excel and Highlight Matches, How to search and highlight in Excel, Highlight search results using conditional formatting, Use conditional formatting to highlight rows, Highlight entire row in Excel with Conditional Formatting, Find matching values in Excel
__________
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

Видео Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets канала Sharon Smith