Excel - Find Matching Values in Two Worksheets, Tables or Columns Tutorial - Part 1

In this video tutorial learn how to find matches in two worksheets in Microsoft Excel.

[li-arvergara]

Thank you for this! its the easiest tutorial ive watch for comparing files on excel!, once again, thank you and your team!

[kanikamahajan]

This is the most clear and concise matching video I have found! Please keep uploading and thank you for the great work :)

[nagyeiokyere]

Wow... Finally I don't have to waste time looking for them manually... God bless you sir

[fatimahismail]

Thank you! Much appreciated. I was on the brink of a mental breakdown and found you! You saved meee

[billblake]

Brilliant work. Clear concise and useful without trying to be too fancy.
May I ask if there is a simple way to return Yes/No instead of True/False.
Thank you.wonderful series.

[jam]

This was easy to understand. Thank you! I need to compare text in two different lists (versus numbers). Do you have a formula for that? For example, if you wanted to compare column B with column F in this video. How would you do that?

[Horzemama]

I love all your videos! They help me so much. I feel I am now working smarter and more efficiently. THANK YOU!

[nicksierra]

Dude, Thank you so much for your videos! I built an automated system as the infrastructure for my tutoring company by watching your videos. Your videos have been really helpful

[mrCetus]

Great tutorial! Easy to follow. Simplified what others have over-complicated!

[amandashotts]

super helpful! I've watch a couple different videos and didn't understand the concept until watching this. Can't believe it is so simple. Thank you so much

[boriqua]

Oh my gosh I love you! I’ve watched so many videos and none of them clicked for me until I watched yours. You saved me so much time at work 🙌🏼🙌🏼🙌🏼

[oayodele]

I searched through about 20 videos to understand Vlookup and this was the most helpful one! Thank you so much from a very beginner in Excel!

[imeldajevee]

Short and to the point. Exactly what i needed. Thank you

[ontresiciaaverette]

Thank you so much! This was quick and to the point - love it.

[sanalyasir]

Thank you so much man i was worried how to sort out my list and then i got the idea of searching the topic and found your video and finally i could save my many hours, Thank you man. Keep up the good work

[johnn]

You should do more creative app script ones. Those were a blast! Im actually solving big problems at work based on the building blocks you gave me man. You should build an entire big project and incorporate javascript .

[sc]

This was very helpful, I was so used to using vlookup between two spreadsheets it never dawned on me that I could use it within the same spreadsheet.

[tkev]

Thank you for simplifying! You are my go to now!!!

[shivanshG]

You are very articulate and good at teaching!

[komalcreativity]

Hiii
I am from India🇮🇳🇮🇳
Nice 🤗
Keep it up Sir👏🏽😊