How to Use VLOOKUP to Compare Two Lists

[@SimonSezIT]

**GET FOUR FREE COURSES!** ► www.simonsezit.com/four-free-courses We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u Check out our FREE 300+ hour training course playlist here ➡ 🔥kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@liarcheckmate701]

You're a hero. A real hero. Felt incredibly doltish for not being able to even find a tutorial that made sense. You did and you're a great human for it. Enjoy your life!!!!

[@SimonSezIT]

Thank you so much for your kind words! I'm glad the tutorial helped you out. 😊

[@RobertTheTexan2]

Thanks for the VLOOKUP life preserver. You are so appreciated!

[@SimonSezIT]

Thank you so much 😀

[@ibrahimahmad72]

I have been watching your videos, for 3 days And there's no words to be described, You're just amazing, Thank you!

[@SimonSezIT]

You're welcome! We're so glad you're enjoying our videos. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@songedeau]

Been trying to figure this out for YEARS. It just clicked! Thank you for making this very clear.

[@SimonSezIT]

That is great, thanks for sharing 😊

[@fivetimesyo]

Oh my goodness! You are lifesavers! Wonderful narrator and brilliant process. Thank you so much.

[@mimi3118]

Happy to have opened this post as this helps a lot as i 'm just new in my new role at the office and i need a lot of reporting/comparing cases to do! This is much appreciated!❤

[@SimonSezIT]

Glad you think so! Thanks for leaving as comment ;-)

[@HKRotich]

Brilliant!! I'm an Accountant, tracing missing invoices from Revenue Authority was my biggest problem.

[@محترفينمصرفيالخارج]

Is it the right function to use with bank reconciliation in excel please ?

[@gaylemusgrove872]

🥰Thanks!

[@SimonSezIT]

You are very welcome and thank you so much for your support! We really appreciate it🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support! #SimonSezIT #Excel

[@rubenvargas4233]

This is the most comprehensive video explaining what to do. Thank you so much.

[@SimonSezIT]

Thank you for your kind words! I'm so happy that the video was able to provide you with the information you needed. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@LC-og4by]

Exactly what I was looking for. Thank you for making a potentially complicated process clear and easy to follow. I’ll be watching again.

[@ajayg9057]

I wanted to do this for a large set of data, I also wanted to show the missing values with a different formatting. This video helped me understand that I was able to do all the required stuff quickly and efficiently. Thanks a lot!

[@VP-yp8ip]

This is really helpful. Now I’m able to compare my reports more effectively.

[@SimonSezIT]

Thank you so much 😀

[@il_Presepe]

This was stellar! Clear. Detailed. To the point. Thank you very much for making and sharing this video.

[@bscott4040]

I've been watching vlook up videos since 9am and had yet to review one that explained it perfectly! THANK YOU!!! I am now able to assist in expediting several manual processes!!! OMG, you just don't know! I exclaimed YES!!! everyone in the office looked at me spooked lol This has been a Ginormously-Huge gain. THANKS AGAIN!!!

[@SimonSezIT]

So glad to hear that you found my video helpful! VLOOKUP can be tricky, but it sounds like you're on your way to mastering it. Keep up the great work! Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@johnwainaina6773]

Five star explanation of vlookup functions and conditional formatting. Great.

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩

[@teresabourke7551]

Excellent tutorial. Very clear and concise. Thank you.

[@SimonSezIT]

Thank you so much for your kind words! 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@lmg4293]

Really appreciate the way you teach!

[@SimonSezIT]

Glad to hear that!

[@amitabhpaul1501]

This Really helped me a lot, great video, Thank you.

[@SimonSezIT]

You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@maryroseflorendo5586]

This was very informative and easy to understand. Thank you so much!

[@SimonSezIT]

Glad you found it informative! Your feedback means a lot. 😊

[@labeed2652]

I usually use "IFERROR" function for that, but "ISNA" looks helpful too, and it's another tool to use... always good to know more than one way to handle things. Thank you for this informative tutorial!

[@SimonSezIT]

Happy to help!

[@omarsanchez9709]

This helped me a lot in my accounting job. Issues with operations team backdating job numbers without letting accounting know. Therfore running this report using v look up helped call them out

[@halilpotoku3395]

the best explanation about vlookups,

[@SimonSezIT]

Glad it was helpful!

[@jokorah181]

Very clearly explained. the video covered all that was required. Thank you so much!!

[@SimonSezIT]

Thank you and you're very welcome!

[@EmmaGood-c2y]

Thank you for clearly explaining how to do a VLOOKUP :)

[@luisvillasenor6081]

Best Tutorial ever O.O!!!!!!!!!!!!!!

[@sumanrokkala2708]

nicely explained and I could able to implement easily. Thank you.

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩

[@MarioMarioD80]

in addition you can use the function 'ifna(function, return value when na)' - or 'iferror(function, return value when error)' which will also cover div/0 etc. also useful if you rather want to leave the cell empty

[@JaymyT-y2e]

MEGA!! Excellent explanation and flow.

[@SimonSezIT]

Thank you for the kind words! Glad it was helpful. 🤩

[@21stcenturyafropolitan]

GREAT CONTENT. HIGHLY HELPFUL.

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@nicollettegyles6859]

Exactly what I needed!!! Thank you so much

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@DashCLO7]

Thank you very much for this. This is indeed useful.

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂

[@adinamohamed9806]

Thank you so much for the very easy guide. The explanation was clear, precise and step by step. Looking forward for more videos.

[@SimonSezIT]

Glad you think so, Adina. Thanks for watching!

[@jacquelineloz4572]

Thank you for explaining this, everyone else always uses technical terms and it doesn’t connect in my head.

[@SimonSezIT]

Glad you like them! Thanks for watching 😊

[@ExcelEssentials_]

Pro tip! When you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right!

[@wiredblitzen]

After looking at so many other tutorials this was the best articulated. Thank you soooo much

[@LesetjaMadiba-v4m]

Found it very useful thank you

[@SimonSezIT]

Thank you so much for your kind words! Thrilled to hear that you're finding the content helpful. 😊

[@HD-ct5ne]

This was extremely useful. Thanks a lot!!

[@beyobeya]

I had similar experience last year wherein I needed to compare a list of 400+ tickets our team has against a list from our Finance team. I did the same process (VLOOKUP, IFERROR, and Conditional Formatting) which was great but I noticed that some items can be in file A but not in file B, or vice versa. That vice versa thing was a headache for me. Looking back at the situation, I think I may just did an overthinking and that I could have just done the same process in both directions.

[@jasonwilson1818]

Great lesson and video, thank you!

[@SimonSezIT]

You're welcome!

[@lalatorvike6077]

You’re a life saver. Very clear and precise.

[@SimonSezIT]

Glad it helped Lala 😊

[@believerinyhvh8586]

Love the explanation but do you have a spread sheet so I can try the formula as you explain?

[@FaceSatchel]

Thanks for this. Really helped.

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@vigneshv8445]

Excellent one this one is what i really wanted...Thank u

[@SimonSezIT]

Happy to learn it was helpful, Vignesh :-)

[@johnherbert2362]

love this function, thanks

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@tenajiawilliams5702]

You've explained this so clearly! Thank you!!

[@SimonSezIT]

Glad you liked it! 😊

[@janellebryant2136]

Great tutorial!! THANK YOU!!!

[@SimonSezIT]

You are very welcome! Thanks for watching :-)

[@lseh]

I love this! Thanks!!!

[@SimonSezIT]

So glad! Thanks for watching :-)

[@alexrosen8762]

Excellent tutorial

[@SimonSezIT]

Thanks Alex!🙂

[@Cora_la_flor]

This is so helpful. Thank you for being so clear and precise.

[@manleedragon9834]

Easy to understand the steps

[@mexifrida]

Thank you!

[@BESTMACKY]

Wow! This will be very helpful. Thanks for sharing.

[@SimonSezIT]

You’re welcome 😊 Thanks for you watching!

[@floydguel4238]

Thank you !!

[@wue42]

great work! well done! now I see it clear ... ;-)💯

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@osmankhalidmohammed]

Really helpful

[@EdsonNascimentoEN]

Great tutorial thanks for sharing.

[@SimonSezIT]

Glad it was helpful! Thanks for watching 😃

[@esubalewabebe6519]

thank you very much!

[@SimonSezIT]

You are very welcome! Thanks for watching 😃

[@DivyaSingh-hf4cq]

Thank you for sharing the video

[@SimonSezIT]

Thanks for watching, Divya!

[@AhmadNubliMuhammad]

superb. thank you

[@SimonSezIT]

You are most welcome 😊

[@kpogiorbaritema3852]

thank you GOD Bless you

[@SimonSezIT]

Glad we could help!

[@zakaurrehmankhan8185]

Found very helpful

[@SimonSezIT]

Glad you think so, Zaka Ur Rehman Khan :-)

[@Payton-Prescott]

Amazing video, thanks! I have recently used extraktAI for Vlookup, but it was for customer and product ID, it also worked really well!

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@hazelamican2596]

Thank you for this can I request for sample excel template touse for practice thanks

[@spicypiscey5056]

Fantastic

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 😃

[@acenabo61]

Clear ❤

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@minalc4598]

Thank you for the help

[@johnq3543]

Thank you

[@MayWongMY]

very useful

[@SimonSezIT]

Glad you it was helpful. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@yavorkrustev]

awesome!

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@hishamfathy6051]

great thank you

[@GanaOk]

SUPER.!!

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 😃

[@joannachung3642]

Sorry. It works perfect on worksheet but "wrong formula" in conditional formatting. I tested separately in two separate columns but got the same result. I am using Excel 365. May I know why? Many Thanks.

[@rose_shimmerling]

Awesome! Thanks.

[@SimonSezIT]

You're welcome!

[@MsChari40]

Thank you. I did it!!!

[@SimonSezIT]

Congrats!

[@davea.1989]

Good day, what if the details are not exactly the same like the names have the titles i.e “dr” or it’s the first name that comes first instead for the last name

[@muralimohan3392]

Thanks

[@merinarajkarnikar5946]

Wow ❤❤

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂

[@duahkwaku8286]

How do we get the data to practice with it.

[@mykola_kanyuk]

brilliant

[@SimonSezIT]

Thanks! Delighted you think so!

[@mir22v]

good explanation, but image is very blurry.

[@ilonadraznina5425]

Hello, thank you for useful video, maybe you can add how I can compare 2 lists and add missing data? For example, if I have "Taylor Gross+ in the Column 1 but don't have it in column 2, I want to add "Taylor Gross" to column 2.

[@Chrisbajs]

Fantastic video. Only gripe I have, is that sheet number two (Employees 2) is called almost exactly the same as the named datarange (Employees2). Can be a bit confusing.

[@HussamQazi]

Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?

[@jennifergage5119]

My Motion looks nothing like that....How do I color code?

[@ellahrasonabe9821]

Great

[@mariberggren9147]

What if we are searching for approximate values instead of exact?

[@tomclark2203]

I tried this on two datasets I am trying to compare and every result is #N/A. I know there are values that match between both. I verified all cells are formatted as text. Not sure what else I can do to resolve the error. Stumped.

[@pabs000]

Try, =IF(A1Sheet2!A1,"Missing Record",""). Thanks to Seiha Sky for suggesting.

[@dennohism]

Great!

[@suejaz8085]

i have a problem.. all is good when i did the formula on first cell. but when i drag to have the formula in subsequent rows.... it just copies my answer on first row.. to all subsequent rows..

[@Vividvibes_4]

Can someone share me a link through which I can learn stock count or like I have a huge sayad which is present stock available and physically count stock with quantity and how to workout to find the variance. Thank you in advance for your help

[@sadigon2007]

great

[@thandonkalitshana2024]

What if you want to compare more than 1 Collum

[@Holmesisaok]

Thank you baby jesus for this help

[@sameeraprasadpannila563]

What a voice

[@SimonSezIT]

Thank you so much for the kind words!

[@floragill1200]

QUESTION: I have 2 lists that were generated by 2 different databases. one formulates names DOE, JANE SARAH...the other formulates each name in a different column and every name written as Doe Jane Sarah instead of upper case. So I CONCAteNTATED the names from the list that had the name separated in columns, then I did =UPPER() to make the names all upper case. I then copied and pasted as a "paste special" so that it copies as the final value instead of the formula. so the names look exactly the same. Then i tried conditional formatting and couldn't find any matches, even though I know there were at least 10 just visually. then, to add to the mystery, I hand typed one name in the same format as the DOE, JANE SARAH... and this is the only name that matches with conditional formatting or VLOOKUP. I've diddled around in a few cells just to see if there are extra spaces or something and it doesn't seem like it. I copied it into googlesheets and tried conditional formatting and got the same weirdness. What am I doing wrong? why are these names that visually look 100% identical not finding their matches? help!

[@ubaidillahmuhammad20]

nice. put practiced file in the description video ...

[@RobertTheTexan2]

I have watched, let's just say, "my fair share" Excel VLOOKUP videos, but they did not click click with me. This video clicked. It all made so much more sense than the other "experts" out there. The first time through I was like Ohhhh that's how I need to view the Lookup Value. You gave criteria for it and you made it MAKE SENSE. So I was pretty stoked when my VLOOKUP actually did what I wanted it to do. Then I got my data cleaned up with your other tips and tricks. Lastly, I do appreciate the context you provided for your examples. If there was an award for "Best VLOOKUP Video on the Interweb" You should certainly win that award, and I feel so strongly about that, I would likely throat-punch anyone who disagreed with that sentiment. :-) JK. Probably. Also a very pleasant voice. Not an "I'm a super brain and you're a moron voice, just a pleasant, confident, knowledgeable voice. Thank you for saving me from VLOOKUP hell. You are Awesome Sauce, no doubt about it.

[@SimonSezIT]

Oh wow, we are so stoked by what you just said. Thank you so much, as much as we are glad that you found our tutorial/s helpful. 😊

[@msbee861]

I followed the steps, and my results were 0. Is there a reason it keeps coming up as 0?

[@michelewalter1939]

My version wont let me name the table.... :(((