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.

[@janetdesenzo7502]

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!

[@khrisiamariemondragon4045]

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

[@sammee1977]

I couldn't follow those vlookup videos to save my life. Watching this video was 9 minutes well spent. Thank you so much! You're an excellent instructor.

[@fj8623]

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!

[@ExcelGoogleSheets]

😀 You can actually connect directly to your SQL server in Excel, that way you wouldn't even have to import anything.

[@ronbuzil5839]

I've been using Excel since, well since Lotus 1-2-3 was a thing, and I learned a lot from this video. It's clear and explained well. Thanks.

[@ExcelGoogleSheets]

Great to hear!

[@Dianna369]

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!

[@ghostofreality1222]

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.😀

[@simonbeattie9592]

I don't normally comment on KZbin 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!!

[@RoxxiRockstar]

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

[@ExcelGoogleSheets]

Glad it helped!

[@rubiacampisoares5315]

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

[@nurulrika3075]

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

[@sujim1870]

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.

[@ExcelGoogleSheets]

Great to hear!

[@nknight369]

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

[@jencunnane7025]

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!

[@psilosieni]

Oh my dear god, I love you so much. This is exactly what i've needed!!

[@mauriciogerardoramirezmend4937]

You just solved my problem in three minuts and make me save a couple of hours. Thx a lot man!

[@ExcelGoogleSheets]

Great!

[@rhondaward13]

OMG. I cannot tell you how much you saved my life. THANK YOU!

[@romanicvs]

Absolutely excellent. I was looking for some tutorials on how to merge diverse databases in Excel, and none were really accurate. Thanks again.

[@ExcelGoogleSheets]

👍

[@margostoltz1092]

This instruction video is so helpful! You saved me hours of merging data with vlookups. THANK YOU!!!

[@rcm561]

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

[@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!

[@beckybanning1744]

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

[@ExcelGoogleSheets]

👍

[@ironeez]

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

[@shabtalpur9880]

The only video which solved my problem. Thank you so much. God bless you.

[@ExcelGoogleSheets]

👍

[@dazplay]

Brilliant! I knew there would be a way to do this I just didn't know how. Thank you so much!

[@amitkrishnani1867]

How to do this in google sheet..??

[@chaitranagesh8509]

Really helped... and saved lot of my time... Very thankful.....

[@big1cam]

You are the one! I've been putting off this massive report for months.thanks so much!!!

[@mojeff314]

Great example and walkthrough. Very helpful. Thank you.

[@Kafir_Hindu]

Thanks for sharing this merging technique. It helped me to get the desired set of data

[@beeneealston2137]

Great job!!! I am not going to tell you how many sites and videos I followed, to no avail, before seeing this one.

[@ExcelGoogleSheets]

:)

[@kaleembabai]

Best explanation video ever

[@56-ish]

Thank you very much, great simple tutorial. I've done this before just needed a refresh. Nice, quick and straight to the point

[@omonyeokoedion7325]

Please how do you merge the different csv data into one file that will import all at once, because mine is just importing one data at a time instead of all

[@mansurmerchant7101]

Excellent knowledge displayed...Awesome...!!!

[@saffetgokcensen523]

Thank you very very much for this great video.

[@julianneyeaman6095]

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

[@daylashortt4997]

I must say this was straight to the point, not of lot of unnecessary talking, because sometimes that can be distracting and HELPFULLLLLLLLLL ❤❤❤❤ thank you for creating

[@sajidstar4]

Thank you, Just what I was looking for!

[@findthetruth3021]

Wow, it was amazing, but that would be way better to put the files below the video as a link so that we can download it and repeat the same thing that you did. Many thanks again for this fruitful and productive video.

[@darthvader_]

People on YT should delete there method to merge after watching your video. This was so frustrating. Thanks a ton!

[@swanmute5713]

It helps me a lot, thank you very much.

[@4Jibran]

Thank you so much ....Clear and specific information. Helped me learn. God Bless you Sir .

[@laurablake4759]

This is great. Thank you! Vlook up's are time consuming and confusing.

[@mariamaleem7917]

You are a life saver!

[@sraoarjun]

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

[@wanjadouglas3058]

Thank you for the lesson

[@MikeVince-kl8cl]

Excellent explanation! Thank you, thank you, thank you. :-)

[@QuestzO]

U saved me mahn..thanks..I'm your new subscriber ❤

[@tsogkhuu]

Amazed. great. helpful. liked. subscribed.

[@vivekdoke4554]

Thank you very much! Can we automate these steps using Macros and make more interactive for better usability?

[@shifanarahman34]

Really grateful for this class and explanation.

[@ExcelGoogleSheets]

:)

[@HanishGuptaHoney]

Thanks. It saved my time and effort.

[@manishbej7505]

Really helpful, thanks 👍

[@vivekjain9048]

Thank You for sharing this wonderful feature of excel. Saved time and effort. Much appreciated.

[@ExcelGoogleSheets]

Glad it was helpful!

[@Valliant79]

Thanks LGS, I really appreciate this video. Awesome

[@YogVaasishthha]

May God Bless you!! Such a nice work!

[@AlokKumar-cl9mf]

Thank You so so so much it works for me 😊👌👌🙏🙏

[@michaelr1179]

I never post/comment on stuff. BUT, MY GUUUUUYYYY....Thank you... Thank you.....

[@ExcelGoogleSheets]

👍

[@Pooh991]

Thank you so much. Your video was clear and well-explained!! I really appreciate it! It helped a lot!

[@andreacastillo4051]

THANK YOU!!! I appreciate your help in creating this video

[@laurafaulkner3385]

This is awesome! Thank you for explaining it so clear and easy!

[@ExcelGoogleSheets]

Thanks!

[@emmanueljacobkanagala6734]

Excellent👏

[@AA-fe1zl]

Thank you so much for this helpful tutorial!

[@ExcelGoogleSheets]

👍

[@stevenchapman8114]

well explained. Thanks

[@iramrizvi7185]

Great learning.

[@DevCompany1000]

You saved me $5 on Fiverr!

[@everythingandanything2457]

This is very helpful!

[@ExcelGoogleSheets]

Glad it was helpful!

[@lijunshen9886]

You saved my life. Thanks!

[@shashanksingh7362]

very informative, thank you soo much

[@MaciejJablonski-u3u]

Hero. Saviour. Thank you!!

[@12thatguyoverthere]

You are the best!!!

[@vegetasfitnesschannel446]

Awesome video helped a lot!

[@ExcelGoogleSheets]

Great!

[@katestan7002]

Awesome! Thank you!

[@kiml2328]

This is INCREDIBLEEEEE ! Thank you so much !

[@karenazeez]

You just saved me! Thank you for this video, so helpful!

[@babblecamp]

Thanks this helped me a lot

[@mafukoblaise1820]

This was so incredibly helpful-thank you thank you

[@ExcelGoogleSheets]

👍

[@elenahicks2094]

Very well presented. Thanks for the helpful tips

[@ExcelGoogleSheets]

Thank You!

[@YohannesLeta]

Thank you. This is what exactly I want!

[@carloscortes6669]

Thank you very much!

[@godfreyincmedia5862]

Excellent explanation and content

[@re-unite6828]

Excellent! thanks

[@rahulr6374]

Life Saver!

[@EstevanDrummer]

Great, thanks a lot for this information, really useful in many daily tasks I make.

[@JesusVillalobos1]

I have none of these options on the version I use of Excel, this is exactly what I need to do. Im on Excel 365.

[@ExcelGoogleSheets]

Data -> From Table Range & Data -> Get Data

[@ExcelGoogleSheets]

Also make sure you are on the desktop version, not web browser.

[@robertsalazar2788]

Thank you for the help, this was exactly what I needed and you explained every step perfectly.

[@Maram_71]

Thank you so much🙏🏿🙏🏿🙏🏿🙏🏿🙏🏿

[@ExcelGoogleSheets]

😀

[@eldo1995]

Thank you very much for your video! Although I tried to do this in some smaller files and it worked when I am trying to do it with 2 large files the following error message appears "we were unable to determine how many matches the selection will return". What can I do to solve it? Thank you very much!

[@adanhabibhussein1941]

Thank you so much.

[@magoulakimou]

You saved me! Thank you!!

[@inderjeetbhatia6380]

Thanks. Truly great. You are a life saver.

[@Nikocasme]

Amazing thank you so much.

[@ExcelGoogleSheets]

:)

[@RanaT]

This is so helpful! Thank you! :D

[@apiitg]

is there a way to keep the same formating as the source sheets like cell color.

[@tpsdas]

thanks for the tutorial. But how to make linked with the original sheets? when ever their is any ammendments, it should automatically reflect in the combined sheet

[@ExcelGoogleSheets]

Click refresh on the query.

[@noahobeng-nkrumah4324]

Wow, Thank you boss. This video has been so helpful. I am really grateful

[@beverlysaavedra5521]

Life saver! Thank you so much for this 🙏🏼

[@ExcelGoogleSheets]

:)

[@michelleng6036]

Great video thanks!! One question, if I wanted to merge to colums with data and I want the two colums added up together; is there anyway to put a formula in it? So, instead of adding up first and last name, two colums of data?

[@ExcelGoogleSheets]

Sure. Just go to Add Column menu on top and add the calculated column.

[@michelleng6036]

@@ExcelGoogleSheets thank you so much for your quick and helpful response :))

[@santosahernandezmendoza7147]

I think that also with the Google spreadsheet this work can be done, right?

[@malikhill1318]

Great video! Thank you!