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
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
Also watch our channel videos for improving skills about google drive. if you like my video, please like, share & don't forget to subscribe our Edutech Solution and press Bell Icon also. czcams.com/video/XzTaWXvCuko/video.html
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.
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
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?
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 .
Hi. we play with the workmates who tip the most rows on the Europatipset (Sweden; series of 13 fotballmatches). And now I have created a spreadsheet about who has how most right. Everything works until we have some with the same number of right. I have a formula that finds the most number right and writes in the cell next to the winner's name. But if they are two or more? how to write all the names that are right? Thanks!
Hi. How do I get better at those nested formulas? Like when to use iserror, isnumber, not in vlookup/if etc? I'm ok with only one or two nested but if it gets too many I don't know. Where do I learn? There are mostly only the simple IF, IF and etc on CZcams. I can't find the advanced formulas/functions where you mix a lot of them together Hope you can help.thanks
Love the tutorial it helped solve a lot of the problems I was having with my tables. Is there away to add a new column to the master list that would list the tab name in the master list. to be able to breakdown what information came from what tab?
This is great very clear and informational, Question I am trying to match multiple columns on 2 different spreadsheets Using this video as example, I have a new list of Phone numbers and emails and want to compare to the old list of phone# and emails to see who I need to update... can anyone help me out? thanks
Hello, I do enter a data in one sheet but want to enter the same data in other sheet too only by doing it in 1st sheet and it comes automatically to other sheet (what formula should I go with?)
Hidear thanks for the good series of tutorials its really very helpfull for people like me ... iam working on excel2016 and have to update daily figure in many sheets (say about 30-50) and then update the same in one master sheet ... is it possible just to update one master sheet and the respective data to also get it update in there respective sheets (30-50)... and vice versa please explain if possible thanks in advance
Question: Sir, If for example I am matching a number on a specific cell but I wanted the adjacent cell to be indicated in the cell where I put on the formula, is that possible? please show me how.
Hi, Could you please help me on this scenario, there are 5 columns in 2 different sheet, some of values matches, some others not matches. If this A1=A1 (other sheet) should goes to next step like B1=B1(other sheet) or else give a value like "A1 is not matching with A1 in other sheet. I need formula for this scenario could you please help me on this. Thanks
Hi, That was a lot of help for me. I have question- how can i compare 2 columns between two sheets. For example, i have column ID and amount, i want to bring output "matched" when my both id and amount is matching with ID and amount of another sheet. please advise asap
I have 4 worksheets in which all of them have a primary column named sub_id. Now I have to display the data based on the similar sub_id in all the sheets. Some sheets have some sub_id numbers which others does not. So I want only the data which exists in all the sheets based on sub_id. Thanks
Part 2 - Find Matches Between Two Sheets , Automated - czcams.com/video/3T4duNj7URw/video.html
VLOOKUP & Return Multiple Columns czcams.com/video/XOSfC22VxyA/video.html
Excel Tables - czcams.com/video/cKFMmMfY42M/video.html
Thank you! Much appreciated. I was on the brink of a mental breakdown and found you! You saved meee
Thank you for this! its the easiest tutorial ive watch for comparing files on excel!, once again, thank you and your team!
This is the most clear and concise matching video I have found! Please keep uploading and thank you for the great work :)
Wow... Finally I don't have to waste time looking for them manually... God bless you sir
Short and to the point. Exactly what i needed. Thank you
I love all your videos! They help me so much. I feel I am now working smarter and more efficiently. THANK YOU!
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 🙌🏼🙌🏼🙌🏼
Great tutorial! Easy to follow. Simplified what others have over-complicated!
Thank you so much! This was quick and to the point - love it.
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
Great to hear!
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
Also watch our channel videos for improving skills about google drive. if you like my video, please like, share & don't forget to subscribe our Edutech Solution and press Bell Icon also.
czcams.com/video/XzTaWXvCuko/video.html
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.
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.
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
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?
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!
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 .
Thank you for simplifying! You are my go to now!!!
You are very articulate and good at teaching!
I understood more from this video than from my Excel teacher!! Thank you, thank you, thank you so much!
Sweet! Very nice presentation... I learned something before my ADD kicked in!
Thank you! This helped me so much! :)
Thank you so much! This was immensely helpful! It's exactly what my team and I needed.
Thank you. This was straightforward and easy for me to do in less than a couple of minutes.
👍
THANK YOU!! WORKS GREAT!!
So helpful. I used this today and it totally helped me.
Thank you , really it's very needful .
Hey great video, really helped me out!
This was inexplicably helpful. Thank you so much Google gods!
great video man, thanks for uploading the video
Thanks a lot you made my day bro.....GOD BLESS YOU.
Exactly what I needed. Thank you so much.
Thank you, this saved me!
Thank you so much!!! You saved my day!
Help me tremendously with my work, thanks!
Glad to hear that!
Very Informative about match function
Dude, thanks for this tutorial, it saved a ton of time at work :)
I love your voice and system, absolut!! :D
Amazing video...thanks so much....saved me hours!
Great stuff. Thanks for being so clear and concise.
Hiii
I am from India🇮🇳🇮🇳
Nice 🤗
Keep it up Sir👏🏽😊
Excellent description, you made it so simple while many people made it look difficult.
Thank you so much,very useful for me ,this video
Thank you so much. Easiest video.
superb... thanks you guys
Great. Thanks so much for this!
I am doing this step by steps and it works!
thank you, thank you, thank you.
Excellent!
Thank you so much God bless u..excellent content, thanks fr ur effort,
You save my life, thank you!!
Big thanks Bro. My work gets easier..
Helpful functions! Thank you for your videos.
I love this video! super helpful. I have not understand this during school days 😅
:)
Great tutorial! Helped tremendously!
Glad to hear it!
This is so helpful! Thank you!
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
Thank you! 😃
actually this is a very good explanation, respect you, sir
Thanks!
Easy to follow and answered why Match vs. Lookup
Easy to understand, thanks man
Thnku thnku so much for this video sir.
Very help full video thank you so much
Hi, THANK YOU! 😊
Thank you so much!!
THIS IS AMAZING. THANK YOU!!!
Hi. we play with the workmates who tip the most rows on the Europatipset (Sweden; series of 13 fotballmatches).
And now I have created a spreadsheet about who has how most right. Everything works until we have some with the same number of right.
I have a formula that finds the most number right and writes in the cell next to the winner's name. But if they are two or more? how to write all the names that are right? Thanks!
Very helpful thank you!
Great video and explanation Sumit
Hi. How do I get better at those nested formulas? Like when to use iserror, isnumber, not in vlookup/if etc?
I'm ok with only one or two nested but if it gets too many I don't know.
Where do I learn? There are mostly only the simple IF, IF and etc on CZcams.
I can't find the advanced formulas/functions where you mix a lot of them together
Hope you can help.thanks
Love the tutorial it helped solve a lot of the problems I was having with my tables. Is there away to add a new column to the master list that would list the tab name in the master list. to be able to breakdown what information came from what tab?
There is a way, it's difficult to explain in a few words however.
Excellent! Thank you!!
Glad it was helpful!
This is so helpful. Well done! Do you have a 'power query' tutorial? This video mentions it but then ends kind of abrubtly.
The following parts are here czcams.com/play/PLv9Pf9aNgemsryBpU4AhSlh_17QaUwjIn.html
Big big thanks brother.
Thank you soo much ❤️
Hi, how do I Match or Vlookup on 2 different sheet at 2 different workbook?
Great job!
This is great very clear and informational, Question I am trying to match multiple columns on 2 different spreadsheets Using this video as example, I have a new list of Phone numbers and emails and want to compare to the old list of phone# and emails to see who I need to update... can anyone help me out? thanks
Watch part 3
czcams.com/video/LQegWcmNqN0/video.html
Great.. thanks a lot💚💚💙
Thnx bro 🤜.... U solve my problem thnx buddy
👍
Thank you so much 👍
Hello, I do enter a data in one sheet but want to enter the same data in other sheet too only by doing it in 1st sheet and it comes automatically to other sheet (what formula should I go with?)
Thank you for this sharing
Hidear thanks for the good series of tutorials its really very helpfull for people like me ...
iam working on excel2016 and have to update daily figure in many sheets (say about 30-50) and then update the same in one master sheet ...
is it possible just to update one master sheet and the respective data to also get it update in there respective sheets (30-50)... and vice versa
please explain if possible
thanks in advance
The only way to do this is using VBA, so yes, it's possible, but can be very complicated.
@@ExcelGoogleSheets thanks dear
Can you please let me know more about it what is vba any video link
Question: Sir, If for example I am matching a number on a specific cell but I wanted the adjacent cell to be indicated in the cell where I put on the formula, is that possible? please show me how.
Nice video sir
Thanks man.
Hi, Could you please help me on this scenario, there are 5 columns in 2 different sheet, some of values matches, some others not matches. If this A1=A1 (other sheet) should goes to next step like B1=B1(other sheet) or else give a value like "A1 is not matching with A1 in other sheet. I need formula for this scenario could you please help me on this. Thanks
thanks for this vid informative
Hi, That was a lot of help for me. I have question-
how can i compare 2 columns between two sheets. For example, i have column ID and amount, i want to bring output "matched" when my both id and amount is matching with ID and amount of another sheet. please advise asap
Combine the columns =A1&"_"&B1 and then use the new column for matching.
Can you make a video on how do you match 3columns of data to other sheet?? And produce true if you found the same value
What to do if I need to check matches between three datasheets?
Thanks for this video, it helped a lot.
Do it between the two and then repeat for the 3rd one.
@@ExcelGoogleSheets That's a clever idea! Thank you again.
Helpful video👍
Thanks!
Thanks for sharing thia
thank you so much....
Thank u so much bro🙏
👍
Thank you so much..☺️👍
Thank you
Helpfull 💓
Thanks Buddy
Can you provide the Excel file that you use for this lesson?
I have 4 worksheets in which all of them have a primary column named sub_id. Now I have to display the data based on the similar sub_id in all the sheets. Some sheets have some sub_id numbers which others does not. So I want only the data which exists in all the sheets based on sub_id. Thanks
dude! you're amazing thank you!