Excel - Merge Data from Multiple Sheets Based on Key Column

Learn how to merge data from multiple worksheets based on a matching key column in Excel without using VLOOKUP function.

#excel #data #merge #tutorial

[mayankkumarthakur]

God damm. I was so sick of vlookup. When I really need to do vlookup, it backfires. But this method is working for me even when vlookup is not. Thanks man. Your are a legend.

[janetdesenzo]

You just saved me so much time. This is so much easier than repetitive VLookups. Your video was excellent - clear and concise. I can't thank you enough!

[khrisiamariemondragon]

Been working on a spreadsheet for the whole 8-hour shift and couldn’t figure anything out and I just saw this 😭 total lifesaver!!!

[Dianna]

This is SUCH an improvement over 2013. Doing this sort of table merge used to be a special sort of torture.... Thank you for posting this!

[simonbeattie]

I don't normally comment on YouTube videos, but thank you so much! I've been needing to merge a number of datasets in work and this is perfect. I was worried about having to do loads of vlookups lol!!

[jencunnane]

This was so incredibly helpful-thank you thank you thank you! It was exactly what I needed, and you explained it so clearly. Huge help to me!

[MicahLouiise]

omg thank you! the way you teach is impeccable, it's like you're in my mind and know exactly what I need to know and the process of how to do it!!! amazing. thanks so much!

[fj]

Excellent! I had raw SQL data stored in several different tables from a relational database that I needed to join into one table based on two specific ID columns. I'm not an SQL programmer, so didn't know how to put it together in SQL. But this video got me to my solution in Excel after importing each table as separate worksheets via CSV. Very appreciative. Good work!

[Clairebelfort]

This is amazing. Saved me a tone of time and it was super simple to follow, wow thanks

[ghostofreality]

Thanks VM for this video, it got me on the right path. After trying for almost 30 mins on the Query option, I had to move it back to the worksheet. I started messing with VLOOKUP function as you did in this video also, but then came across XLOOKUP function, that worked like a charm for what I was doing. Again big thumbs up man you got me on the right path when I was lost on this one.😀

[ironeez]

This was brilliant and you explained it so clearly. Thank you!

[nknight]

Excellent instructional video! I am a novice and I found this easy to follow. Thank you!

[beckybanning]

Fantastic. Exactly what I wanted and an extra bonus at the end about how to merge first name and surname. Thank you so much!

[nurulrika]

Thank you!! I wish I found your video before I got frustrated with many Vlookups and duplicate check, life safer!

[sujim]

Thank you for this video. Usually i watch more than one video to fully understand something. This time i did it in just one go. This was very helpful.

[sraoarjun]

So very well explained and spot on !! Thank you for the good and clear instructions

[rubiacampisoares]

That's gonna be my favorite video of 2020! Thanks!

[julianneyeaman]

Thank you for the clear instructions. Your method worked perfectly and solved a reporting problem for me.

[rcm]

You are my hero! I have bee. Looking for exactly this, and the way you taught it is perfection! Thank you!!

[RoxxiRockstar]

You just saved me HOURS of work. Thank you so much!