I spent an hour trying to get it working while at work. Of all the vids I watched in growing panic, this was the most helpful. Thanks and definitely subscribed!
@@lilyy2098 I am so happy to hear that you found my video tutorial helpful. Thank you so much for leaving this lovely comment. It truly helps me in keeping motivated.
Thank you for the feedback, Joe. It helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Under 5 minutes? Thank you! I don't understand the videos on this subject that are 10, 15, 20 minutes long! I totally ignore them. Thanks again for being short and succinct!
Thank you for the feedback Wayne, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback Abdul, I'm happy to see my work was helpful to you. The feedback helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you Syed. I was so silly i have been sorting data manually 😂 and it was draining me. I asked Chat GPT it gave me Vlookup and watched your video to help understand better.
Thank you for the feedback Sijuade, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback Sijuade, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
This was really, really helpful and I'm immensely grateful. I especially appreciate the time you took to call out in the vLookup formula what the elements of the formula are doing, what they're referencing. It really helps to solidify it in my mind. Oh, and supplying us with some data sets to practice with? Absolutely wonderful. Thanks again.
Important 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! Good luck 😊
Thank you for the motivational feedback, Alsam. It helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback Moe, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for this lovely feedback, Joseph 😊. You made my day 😀 Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback Luca; it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
You are welcome! Thank you for the feedback. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback Gafoor, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Hello Sir, Good Morning. I understood this, but I have a query, considering one cell value, I want to pull all the row values at once By entering "Yes" to provide all single row data in one stretch, if "No" means not to pull the row data and have to skip for next. Kindly need your help on this. "Scenario is CRM data. With common database with multiple CRMs." Consider
Thank you for the feedback Sunny, it helps in keeping me motivated. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback Nduta, it helps in keeping me motivated. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates. Best Regards, Syed H
What if my data is not in order but i still need exact match like in previous sheet my name is in top but in another sheet its in middle but I don’t want to sort by doing ascending order. How can we find data
What if I have my main workbook saved on onedrive and I want to automatically pull data from reports (other workbooks) that would be saved locally? And what if I'll be doing this on multiple computers (the reason it's saved in the cloud in the first place)?
Thank you for your message. Please make sure the data you trying to lookup inside has an entry for the value you are trying to check. #n/a usually appears if a formula can't find a referenced value.
You are strongly welcome Omwami! Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Hi i am not able to fetch with vlook the email Id on shared workbook under see it as discussed on the video . Kindly share the formula to fetch email ID
How to get dynamic values using different workbook For example first workbook contains list of vegetables and fruits, the price changes every day. In the second workbook it has to calculate the total purchase value for each customer
how to put vlookup from 3 sheets in single column, for example, we have to get salary, from different departments, into master sheet, where all employees are listed.. Salary column to be updated from 3 different sheets
Hello there, you just need to start writing the function, and it will build automatically by picking references from other workbooks. You may share more information about your question so I can help you with that further if the above does not help you. Best Regards, Syed H
Hello Trudy, are you doing this on the practice file? if yes, share the function you are trying. If you are using your own data, please share some sample data on my email so that I can have a look. Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6
Hello Trudy, Got your sample data file. I was able to fetch the values with no issues. I did not get your email correctly. Please send an email to me on hussaini.syed@gmail.com and I can reply to you with a copy of the file that worked for me. Best Regards, Syed H
Please let me know the steps you are performing, and your data sample so I can take a look and help you with that. You can use this form to submit your data: forms.gle/M3s9fiSJjrANk6fv9
Dude I swear Vlookups hate me. I do all of this in my project and it still returns NAs... Is there something with like the order of the columns or something?
Please let me know the steps you are performing, and your data sample so I can take a look and help you with that. You can use this form to submit your data: forms.gle/M3s9fiSJjrANk6fv9
Very easy to understand and follow it. Great explanation, thanks
I spent an hour trying to get it working while at work. Of all the vids I watched in growing panic, this was the most helpful. Thanks and definitely subscribed!
Thank you for the feedback Raven, it helps in keeping me motivated.
Best Regards,
Syed H
Yes exactly ... I found so many videos n this was the best i got it in 1st try.. thank you so much
Exactly
thank you so much for this informative video
omg, i did it!!!!!! thank you so much teacher!
@@lilyy2098 I am so happy to hear that you found my video tutorial helpful. Thank you so much for leaving this lovely comment. It truly helps me in keeping motivated.
Thank you very much. easy, fast, to the point without all the other talks.
Thank you for the feedback, Joe. It helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
First video in my life where the work book is also given for practice.. Thank you so much.
Thank you for this, I can't tell you how frustrated I was with my formula because it wasn't working. This method made it so much easier for me.
I used to think Vlookup is tough, after watching this video I'm amazed how easy it is and really helped me. Thank you so much brother
Happy to hear that!
May God bless you beyond measures, you just saved me from receiving query from my supervisor.
Under 5 minutes? Thank you! I don't understand the videos on this subject that are 10, 15, 20 minutes long! I totally ignore them. Thanks again for being short and succinct!
Thank you for the feedback Wayne, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Thanks so much, preparing for an interview and this just made me feel much comfort.
Thank you for the feedback Abdul, I'm happy to see my work was helpful to you. The feedback helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Great explanation, thanks
Thank you for the helpful feedback.
Thank you Syed. I was so silly i have been sorting data manually 😂 and it was draining me. I asked Chat GPT it gave me Vlookup and watched your video to help understand better.
Happy to help, thank you for letting me know :)
Your video just saved me 2 days reconciliation done in less than 30 minutes, thanks so much for uploading this
Thank you for the feedback Sijuade, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Thank you for the feedback Sijuade, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
this is very helpful, i used to hesitate to ask my colleagues everytime to help me with vlookup, but now my problem is solved
This was really, really helpful and I'm immensely grateful.
I especially appreciate the time you took to call out in the vLookup formula what the elements of the formula are doing, what they're referencing. It really helps to solidify it in my mind. Oh, and supplying us with some data sets to practice with? Absolutely wonderful.
Thanks again.
Thank you for this constructive feedback, it truly helps in keeping motivated.
Important 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! Good luck 😊
Amazing i watched many videos but I finally got what i was looking for. Thank you so much
Thank you for explaining, in non-programmer language how to do this! I really appreciate it and am now a subscriber!
Thank you for the feedback and the subscription Jeff, it helps in keeping me motivated.
Best Regards,
Syed H
You just made it so easy to understand.
3rd times a charm, 2 videos prior with no luck but this one has worked brilliantly Thank You!
Excellent, very easily explained❤
you are the champ. straight to the point and no BS like others who just want to waste their as well as our time
excel has never been this interesting to learn about
Awesome, thanks
This example is awesome with real life data. Thank you so much
I'm so glad to hear that. Thank you so much for the helpful feedback, Tiffany 😊 .
THANKS! The first one that made sense to me!
Thank you for the motivational feedback, Alsam. It helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
thank you!!!
Hello! Thank you so much for this!!!! 💓💓💓 This is so helpful and I appreciate how you explained everything so simply.
Thank you for the feedback Moe, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Thank you so much for this video and also for the practice workbooks.
Absolute Legend! Champion
Thank you for this lovely feedback, Joseph 😊. You made my day 😀
Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Ur explanation clear. Im successfully do it. Haha. Tq very much
Amazing brother a lota thanks I got from video help thank you so much ❤❤❤🎉🎉🎉
Thank you
Thanks for providing large data set
You are welcome Suman!
Thank you for your message.
Thank you. This was very helpful.
Hey man, honestly this is a good job, so clear and simple, thanks so so so much. God bless you.
Thank you for the feedback Luca; it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Done subscribe i have tried every video finally find this ease my work
Thank You so much God bless you !
It's just great
Great easy to follow video. Does the data remain in Book 1 if you close Book 2?
Thank you sir this is truly amazing, I got a question, can we make 1 single sheet using v look up from different workbooks ?
Good Lesson. Great Men.
Thanks a bunch, this was very helpful. 🙏🏽
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Great concise tutorial... thank you.
Thank you so much.. this video really helpful,easy n simple
Extremely easy , thanks man!
This was soo helpful thank you!
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Awesome, very easy and simple 👌👌👌
Thank you for the feedback, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
This was very helpful
Thank you 🙏🏼
You are welcome! Thank you for the feedback.
Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Good explanation
Thank you for the feedback Gafoor, it helps in keeping me motivated. Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Hello Sir, Good Morning.
I understood this, but I have a query, considering one cell value, I want to pull all the row values at once
By entering "Yes" to provide all single row data in one stretch, if "No" means not to pull the row data and have to skip for next. Kindly need your help on this.
"Scenario is CRM data. With common database with multiple CRMs."
Consider
Could you please email me the sample data so I can help you with that. Please use this form to submit your file: forms.gle/M3s9fiSJjrANk6fv9
You are really awesome
Thank you for the feedback Sunny, it helps in keeping me motivated. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
When u have selected the range u have fixed that value as well right ?
Perfect sir ❤️
Thanks a lot, it was really helpful
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Thank you very much.
Thank you sir,,🙏
You are my savior!
Thank you for this, is there a way that i can combine the two formulas into one and drag it from name & email without entering the formula twice?
you are awesome awesome awesome
Thank you for the feedback Nduta, it helps in keeping me motivated. Please subscribe to my TH-cam channel th-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
How to manage the workbook path, if I send the Excel to another person
What if my data is not in order but i still need exact match like in previous sheet my name is in top but in another sheet its in middle but I don’t want to sort by doing ascending order. How can we find data
What if I have my main workbook saved on onedrive and I want to automatically pull data from reports (other workbooks) that would be saved locally? And what if I'll be doing this on multiple computers (the reason it's saved in the cloud in the first place)?
What if you have last names and and you need to find full name and employee id?
I've tried as you said, but it turned #N/A.
Thank you for your message. Please make sure the data you trying to lookup inside has an entry for the value you are trying to check. #n/a usually appears if a formula can't find a referenced value.
Thank you Sir
You are strongly welcome Omwami!
Kindly subscribe to my TH-cam channel TH-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Hi i am not able to fetch with vlook the email Id on shared workbook under see it as discussed on the video . Kindly share the formula to fetch email ID
Excellent
How to fetch fullname and email using one vlookup formula rather using two times vlookup???
Sir please make a same video if employee repeated twice
Please give this video a try and let me know how it goes: th-cam.com/video/HorO5jgPpJI/w-d-xo.html
like you add your own sample to the soft roll and when you play it it always plays longer than what is shown in the soft roll and
I'm not sure I understand your question.
Is there something you need help with?
And how when closed other workbook then data link disappear?
It does not work when one worksheet get closed
😍
thank you
Thanks.
How to get dynamic values using different workbook
For example first workbook contains list of vegetables and fruits, the price changes every day. In the second workbook it has to calculate the total purchase value for each customer
want to use trim
how to put vlookup from 3 sheets in single column, for example, we have to get salary, from different departments, into master sheet, where all employees are listed.. Salary column to be updated from 3 different sheets
To look up multiple sheets, please watch this episode: th-cam.com/video/_eOqiywG5zs/w-d-xo.html
I hope it helps.
Sir how do I enable vlookup between 2 workbooks? I'm not getting this option.
Hello there, you just need to start writing the function, and it will build automatically by picking references from other workbooks.
You may share more information about your question so I can help you with that further if the above does not help you.
Best Regards,
Syed H
how do i download the practice sheet? tia
Hello there,
You can download practice data using the links inside the video description.
I watched your video many times, i keep getting #ref error, can you help me?
Hello Trudy, are you doing this on the practice file? if yes, share the function you are trying. If you are using your own data, please share some sample data on my email so that I can have a look. Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6
Hello Trudy,
Got your sample data file. I was able to fetch the values with no issues.
I did not get your email correctly. Please send an email to me on hussaini.syed@gmail.com and I can reply to you with a copy of the file that worked for me.
Best Regards,
Syed H
H lookup
This is not working
Please let me know what's happening so I can help you with that.
Please let me know what's happening so I can help you with that.
Please let me know what's happening so I can help you with that.
It's showing name error
Am I the only one who still couldn't figure it out? 🙁
Please let me know the steps you are performing, and your data sample so I can take a look and help you with that.
You can use this form to submit your data: forms.gle/M3s9fiSJjrANk6fv9
Dude I swear Vlookups hate me. I do all of this in my project and it still returns NAs... Is there something with like the order of the columns or something?
Please let me know the steps you are performing, and your data sample so I can take a look and help you with that. You can use this form to submit your data: forms.gle/M3s9fiSJjrANk6fv9
Thanks.
Happy to help ☺️