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, 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
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 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
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 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
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 😊
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.
@@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 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 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 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 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
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
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
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 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
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
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 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
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
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 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.
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
Each time I open the workbook with External Vlookup links I get the following error. "This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them and get the latest data. Otherwise you can keep working with the data you have. There are two buttons. Update and Don't update. Can this issue be solved so these errors do not pop up at all?
To solve this Click "Data" tab, then click "Workbook Links", On the right side in "Workbook links" look for the the Settings button ( gear), click the drop down arrow. Then Click the "Always Refresh" option. The error will not longer show.
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 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
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 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
This is the best, most practical, well-explained, to-the-point excel video I have ever seen. Thank you!
@@TB-fj7kk You're very welcome and thank you so much for adding this lovely feedback. It truly keeps me motivated.
this is very helpful, i used to hesitate to ask my colleagues everytime to help me with vlookup, but now my problem is solved
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.
So helpful, thanks
You are welcome! I am happy I was able to help!
@@Syedhussainipage Very very much, Thanks a lot
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 :)
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
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
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
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 😊
you are the champ. straight to the point and no BS like others who just want to waste their as well as our time
Excellent, very easily explained❤
Amazing i watched many videos but I finally got what i was looking for. Thank you so much
thank you so much for this informative video
You just made it so easy to understand.
excel has never been this interesting to learn about
Thank you so much for this video and also for the practice workbooks.
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.
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.
3rd times a charm, 2 videos prior with no luck but this one has worked brilliantly Thank You!
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. This was very helpful.
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 for providing large data set
You are welcome Suman!
Thank you for your message.
Good Lesson. Great Men.
Great explanation, thanks
Thank you for the helpful feedback.
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
Amazing brother a lota thanks I got from video help thank you so much ❤❤❤🎉🎉🎉
Ur explanation clear. Im successfully do it. Haha. Tq very much
Thank You so much God bless you !
Awesome, thanks
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
Done subscribe i have tried every video finally find this ease my work
Great concise tutorial... thank you.
thank you!!!
Thank you so much.. this video really helpful,easy n simple
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
It's just great
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
This was very helpful
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
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
Perfect sir ❤️
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
You are my savior!
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
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,,🙏
Excellent
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
When u have selected the range u have fixed that value as well right ?
Thank you sir this is truly amazing, I got a question, can we make 1 single sheet using v look up from different workbooks ?
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?
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
Great easy to follow video. Does the data remain in Book 1 if you close Book 2?
thank you
want to use trim
How to manage the workbook path, if I send the Excel to another person
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
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 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
And how when closed other workbook then data link disappear?
What if you have last names and and you need to find full name and employee id?
Thanks.
Happy to help ☺️
How to fetch fullname and email using one vlookup formula rather using two times vlookup???
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?
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
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
how do i download the practice sheet? tia
Hello there,
You can download practice data using the links inside the video description.
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.
It does not work when one worksheet get closed
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
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
Each time I open the workbook with External Vlookup links I get the following error. "This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them and get the latest data. Otherwise you can keep working with the data you have. There are two buttons. Update and Don't update. Can this issue be solved so these errors do not pop up at all?
To solve this Click "Data" tab, then click "Workbook Links", On the right side in "Workbook links" look for the the Settings button ( gear), click the drop down arrow. Then Click the "Always Refresh" option. The error will not longer show.
😍
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.
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
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
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
Thank you
Thanks.