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: [ Ссылка ]
__________
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: [ Ссылка ] for more information, tools and resources.
LinkedIn: [ Ссылка ]
Twitter: [ Ссылка ]
__________
GEAR
🎙 Blue Yeti USB Microphone: [ Ссылка ] (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: [ Ссылка ] (This is a really cool mouse!)
🎥 Screen Recording Software: [ Ссылка ]
📗 Green Screen: [ Ссылка ]
📸 Camera: [ Ссылка ]
🔌 Live Stream Tool: [ Ссылка ] (Turns your DSLR into a top notch webcam)
RESOURCES
✏️ JotForm: [ Ссылка ]
📑 Wondershare PDFelement (PDF Editor): [ Ссылка ]
💻 PresenterMedia: [ Ссылка ]=
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: [ Ссылка ]
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: [ Ссылка ]. 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 [ Ссылка ] 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: [ Ссылка ]
➤Creating Fillable Forms: [ Ссылка ]
➤PowerPoint Tutorials for HR: [ Ссылка ]
➤ Excel Tutorials for HR: [ Ссылка ]
➤ Excel Quickies (Around 2 Minutes): [ Ссылка ]
➤ Word Tutorials for HR: [ Ссылка ]
➤ Welcome | About Me: [ Ссылка ]
Ещё видео!