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.

__________
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 📎
__________
GEAR

RESOURCES

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
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
__________
FREE DOWNLOADS
__________
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:

[briantrinh]

A year later, these instructions and video editing are still high caliber! You made my month! A big thank you <3

[GregATKyruus]

This saved my sanity. Extremely clear directions. Thanks!

[davinderkandola]

You are brilliant Sharon! Easy to understand and exactly what i need! Lifesaver!

[ChuckQuicktossa]

Tina Fey you rock! SNL, and now Excel help online. Honestly though this really helped me thank you!

[CourtneyConnor-xjpy]

This was so helpful and saved me 2 hours of manual work. Thank you

[ingridtrovao]

I love the way you explain and show your screen. Thank you for taking the time to make these videos!!!!

[stooeys]

I’d spent the past 4 hours trying to figure this out! Thank you thank you thank you!!! No other vids could crack it!!! Elated!!!!

[N.TaraQueen]

Wow this just saved me during a data analysis project! OMG. I had watched a couple of other videos but unfortunately couldn't understand them, so yours was perfect. Thank you.

[AlllAboutYou]

Very helpful Sharon. Thank you very much.

[KN-jkcy]

Thank you so very much, Sharon; it's so clear and easy to follow, I Love It!!

[trs]

Thanks *Sharon* That was great. Is possible to pull through data from the row on the small list, where it has a match in the big list, and display that data, perhaps where you currently have true/false, or alternitively in a column created next to it for the purpose of displaying "the pulled-though" data ? Thanks again.

[ramsita]

You are my hero. THANK YOU for this video.

[drewcarpenter]

Amazing, thank you. I'll be watching more of your videos in the future.

[Dwavard]

Fantastic explainer - i was driving myself mad trying other techniques - thank you for posting this :-)

[PerFancyNancy]

This was extremely helpful!! Thank you!

[ecast]

thanks just followed most of your steps saved hours of time

[esoregx]

This video was exactly what I need I watched multiple others and they got me close but I couldn't highlight them first video to actually fully help me.

[wasimmuhammad]

Very informative and easy step by step video.
Thanks

[tonyjohn]

Psych and Chuck?!....love it!

also this was very helpful. Thank you.

[itsdaj]

Great video. I would like it normally, but this like for for the shoutout to Pierre Despereaux.