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 RUclips channel RUclips.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.
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 RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
@@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 Abdul, I'm happy to see my work was helpful to you. The feedback helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.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 RUclips channel RUclips.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 RUclips channel RUclips.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.
Thank you for the feedback Moe, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the motivational feedback, Alsam. It helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.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 RUclips channel RUclips.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 RUclips channel RUclips.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 RUclips channel ruclips.net/user/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 RUclips channel ruclips.net/user/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.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 RUclips channel RUclips.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 RUclips channel RUclips.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, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback Sunny, it helps in keeping me motivated. Please subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates. Best Regards, Syed H
Thank you for the feedback Nduta, it helps in keeping me motivated. Please subscribe to my RUclips channel ruclips.net/user/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
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 😊
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)?
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.
You are strongly welcome Omwami! Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
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 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 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
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
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.
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
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 RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
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!
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.
First video in my life where the work book is also given for practice.. Thank you so much.
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 :)
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 RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
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.
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 RUclips channel RUclips.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
May God bless you beyond measures, you just saved me from receiving query from my supervisor.
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 RUclips channel RUclips.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 RUclips channel RUclips.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.
Thank you for this constructive feedback, it truly helps in keeping motivated.
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 😊 .
Amazing i watched many videos but I finally got what i was looking for. Thank you so much
Excellent, very easily explained❤
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!
thank you so much for this informative video
you are the champ. straight to the point and no BS like others who just want to waste their as well as our time
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 RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
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 RUclips channel RUclips.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
Thanks for providing large data set
You are welcome Suman!
Thank you for your message.
Amazing brother a lota thanks I got from video help thank you so much ❤❤❤🎉🎉🎉
Absolute Legend! Champion
Thank you for this lovely feedback, Joseph 😊. You made my day 😀
Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
excel has never been this interesting to learn about
Great explanation, thanks
Thank you for the helpful feedback.
Done subscribe i have tried every video finally find this ease my work
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 RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Thank you. This was very helpful.
thank you!!!
Thank You so much God bless you !
Thank you
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 RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
Thank you so much.. this video really helpful,easy n simple
Great concise tutorial... thank you.
Good Lesson. Great Men.
Thank you sir this is truly amazing, I got a question, can we make 1 single sheet using v look up from different workbooks ?
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 RUclips channel ruclips.net/user/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 RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Extremely easy , thanks man!
Awesome, thanks
It's just great
Good explanation
Thank you for the feedback Gafoor, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.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 🙏🏼
You are welcome! Thank you for the feedback.
Kindly subscribe to my RUclips channel RUclips.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
When u have selected the range u have fixed that value as well right ?
How to manage the workbook path, if I send the Excel to another person
This was very helpful
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 RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
You are really awesome
Thank you for the feedback Sunny, it helps in keeping me motivated. Please subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
you are awesome awesome awesome
Thank you for the feedback Nduta, it helps in keeping me motivated. Please subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
Perfect sir ❤️
How to fetch fullname and email using one vlookup formula rather using two times vlookup???
What if you have last names and and you need to find full name and employee id?
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
Thank you very much.
Thank you sir,,🙏
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?
And how when closed other workbook then data link disappear?
Excellent
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 my savior!
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)?
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.
Sir please make a same video if employee repeated twice
Please give this video a try and let me know how it goes: ruclips.net/video/HorO5jgPpJI/видео.html
Thank you Sir
You are strongly welcome Omwami!
Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
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?
It does not work when one worksheet get closed
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
😍
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 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: ruclips.net/video/_eOqiywG5zs/видео.html
I hope it helps.
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
thank you
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.
Thanks.
Happy to help ☺️
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
Thank you so much for this video and also for the practice workbooks.
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