Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick

In this Video learn how to use a single formula to find the matches & differences in two lists.

Software Tools/Products by Teknisha:

Recommended Gadgets/Products:

Must Watch Playlists..

Excel Tutorials:

Excel Chart Tutorials:

Excel Pivot Table Tutorials:

Excel Gsuite Tutorials:

Excel Tips & Tricks:

Powerpoint Tutorials:

Gadget Reviews:

Thanks for watching!!! 😊🙏

Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.

Follow me on below to stay connected👇

[neildixon]

This is the most concise and useful explanation I have managed to find on the subject. Thanks a million!

[Mohashm]

There’s always an Indian superhero to save the day when it comes to excel… thank you..

[danielosorio]

Excellent step-by-step detailed explanation. Thank you! First time in your channel and looking forward to your content.

[Mary]

Amazing!! Just what I was searching for🤩 Thank you so much!!

[fts]

Thank you for such a wonderful, complete, incredibly helpful solution to my problem!

[georgerichardson]

this is incredible and really useful - thankyou for your time!

[uniprocrastination]

Thank you so much for posting - I'm very grateful.

[Lorenzo-cpqs]

This is the only video that actually enabled me to match names from two lists in a way that is easy to understand-thankyou. Is it true that to do this with v-lookup, if I have a spreadsheet without a common identifier (such as staff number) that I'm unable to do the match? I had two staff lists- one with unique identifiers, and one without.

[kehaseneway]

SPECIAL Thanks for your supportive and excellent video tutor

[rajeevgosavi]

My long standing problem is solved with this concise and to the point explanation. Thanks a million. Kindly explain how do we apply this formula when we have more than two columns to compare.

[umftjjg]

Great video. Thank you for just getting down to business without glitzy futuristic star wars videos and music. I subscribed and look forward to seeing more.

[giovanni-cxfb]

Phenomenally well explained and extremeley useful. Thank you!

[soneeric]

Thank you for all your videos. You are a great trainer.
Please how can I Compare two lists A and B in different workbooks? List A is the standard. If there are differences in List B, we copy the correct value from A to list B.

[GeorgeAJululian]

Thanks Sir very helpful
Sir if I have four to five lists and I want to compare it with main list and the extract names from main list which are not in other five lists

[nikhilrk]

After searching so many videos, finally arrived at this exact match.thank you

[briantran]

What happens when the list has duplicate names? Will the result be messed up.

[AbdallahF]

Wonderful job very clear and organized

Thank you 🙏

[dpsfx]

If list two had as an example, Andy (Name). How would I set my formula up so I tell excel to use contains Andy because if I am using 0 to return exact value it shows N/A

[mohitsandhu]

You saved my day bro. great explanation

[MrABD-weyn]

Bro I think I need this video. Thnq u bhai