This is great stuff, mate👍🏻👍🏻! Thanks for making the whole learning experience as smooth as ABC for me! Truly appreciate this. Cheers and best wishes to you ❤️🎉
Thank you so very much for your kind words. You really made my day, and I'm so glad that you enjoyed the video all the way through! All the best to you too!! 😊👍
Your voice is SO soothing. Seriously, it's perfect for tutorials. You also break it down so simply and quickly. You made Excel less intimidating. I can't thank you enough!! If I ever need a tutorial made, are you for hire?? (PS -- I'm heading over to buy your premade workbook just to show my support. But I'm going to make it with your tutorial so I can get better at Excel!)
Thank you so much for your kind words. I can't tell you how much feedback like this really makes an impact on me. Thank you. Also, thank you so much for your support as well. It really does make a difference and it means a lot! And for your question, I do my best to pick up custom jobs when I can. So if you are ever interested in hiring me to create a tutorial, just send me an email. Thank you for asking about it.
Wow! Amazing tutorial. Thank you so much! I only had to look up one small of key function because I'm on a mac, but everything was so easy to follow. Wonderful job and thank you!! P.S. You have such a calming voice, you should do a podcast!
Thank you so much for the feedback and for such kind words. You really made my day, and it's so amazing to hear that you enjoyed the tutorial so much. 😊 P.S. - Thank you for saying so. I'm not sure if I ever will do a podcast, but I will certainly consider it at some point I'm sure!
But it's not just about the technical know-how, my dude. It's also about having that creative spark, that vision to see what's possible and then making it happen. You don't just build spreadsheets, You craft digital masterpieces that make data come alive . . . I will gladly spend $5.00, thank you.
Reading this comment really made my day. Thank you so much for all of your kind words. It really means so much! I hope you really enjoy using the password keeper, and I will do my very best to keep good videos coming. 😊
This was the best tutorial ever. Thank you. Quick question. can you make an additional tutorial to add information to your password database using the form? this is pretty good though.
Nice work, easy to follow, did miss that something needed to be populated in $D$5 or you get an na error but I figured as you do visually show it. Great stuff I'm going to apply some other bits for security but this is a fantatsic jump off point and exactly the solution I was looking for 10/10
That is so amazing to hear!! Thank you so much for leaving a comment, and I wish you only the best as you continue taking this spreadsheet forward to meet your needs. 😄👍
hi ryan, once again, you have made a very good impression on all of us with this tutorial! thanks for sharing. a couple of months ago I made a similar spreadsheet for my PW and other personal data. In this time the database as grown to about 100 rows, which makes things somewhat harder to use the dropdown list. is there any way to search the 'description' column? that would be simply awesome! have a great day, colin
Thank you so much for your kind words! It really does mean a lot and helps motivate me to keep going. And that's a great question. If you'd like, send me an email at info@spreadsheetlife.com, and we can discuss a few ideas.
Yes. Once you've entered in all of your data, click on the down arrow box in the description column. You can then choose to sort the data by this column. I hope this helps.
Epic tutorial and one quick question too! How would I go about pulling LookUp info from two separate tabs or rather, a Database one and a a Database two?
Thanks so much!! And that's a good question. I'm sure there is more than way you could go about it, but what I would do is use the VSTACK function to combine the two datasets into one. Then I'd lookup the information from that dataset. Hopefully this helps.
Hi, first of all thanks for this tutorial. Was very easy to follow. Just had a small query, when nothing mentioned in the Notes column in the Database worksheet the result shows 0, can we somehow change this to show "None" or just get a blank cell?
I'm so glad you found this tutorial helpful and easy to follow! That's a great question, and you can definitely update the formula to accomplish what you want to do. Just change the formula in cell G9 to the following. =IF(VLOOKUP($D$5,Database,5,FALSE)=0,"None") If if the VLOOKUP function returns a 0 (when there are no notes), the IF function will then return "None" as your final result. If you want a blank cell instead of "None", then changw the formula to this instead. =IF(VLOOKUP($D$5,Database,5,FALSE)=0,"")
If you are having problem with the dropdown box, it might be due to your range name. So I'd say, check that to see that you have it right. You can view your range names by clicking the down arrow in the Name Box.
Good morning, thanks for the video, I need your help because I follow steps by steps but when I tried to enter the formula on data validation, excel show me an error message that I need to type apostrophe before an equal . I do it but I cannot see the list just show me on the cell the name, and I cannot do it anything after that
The best way for me to help would be for you to send me an email at info@spreadsheetlife.com. Attach your spreadsheet, and I can take a look at it for you.
Unfortunately, this will not work. Once you transfer the template to Google Sheets, you will lose the formatting on the table, and get an error for all of the formulas. I'm so sorry that's the case.
🤚I have a question...what happens when I have multiple Google accounts (or multiple any accounts)? Do I need to name the description with a unique name or will I be able to return multiple results? Or is this something on a more advanced password manager?
In the case of this password manager, you would need to make the descriptions unique. It would definitely be possible to build a password manager in Excel that returns multiple results with the same name, but it would work a little differently than this one.
Okay, great tutorial.. but here is the issue i have with making this thing to work. MY office Excel does not take the VLOOKUP Formula, it shows me an error, he also changes the "$D$5" to "LOOPUP!" when i chaange that back it also shows me the error. i am using office 2024, does that has something to do with it ?
Hmmm...that's strange. VLOOKUP has been around for a long time, so it shouldn't be causing you any problems. If you'd like me to take a look, send me an email at info@spreadsheetlife.com.
No need to apologize at all. That's a great question! Just follow these steps. Go to File > Info > Protect Workbook > Encrypt With Password Enter your password. Click ok. Enter the password again. And click ok. I hope this helps.
For something like this, a pivot table is probably unnecessary since you we are just performing a simple lookup. However, I will do my best to include pivot tables in future videos so you can get some good practice in. 😊👍
Quite a few things will be the same, but there are some key differences. More than I can explain in a comment response unfortunately. If you're interested to learn more about what you can do, send me an email at info@spreadsheetlife.com! 😊👍
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
This is great stuff, mate👍🏻👍🏻! Thanks for making the whole learning experience as smooth as ABC for me! Truly appreciate this. Cheers and best wishes to you ❤️🎉
Thank you so very much for your kind words. You really made my day, and I'm so glad that you enjoyed the video all the way through! All the best to you too!! 😊👍
Your voice is SO soothing. Seriously, it's perfect for tutorials. You also break it down so simply and quickly. You made Excel less intimidating. I can't thank you enough!! If I ever need a tutorial made, are you for hire?? (PS -- I'm heading over to buy your premade workbook just to show my support. But I'm going to make it with your tutorial so I can get better at Excel!)
Thank you so much for your kind words. I can't tell you how much feedback like this really makes an impact on me. Thank you.
Also, thank you so much for your support as well. It really does make a difference and it means a lot!
And for your question, I do my best to pick up custom jobs when I can. So if you are ever interested in hiring me to create a tutorial, just send me an email. Thank you for asking about it.
great tutorial and clear voice
😊👍
Great tutorial! Just followed your instructions and it works perfectly. Thanks so much.
That's awesome! I hope you love using the workbook! 😊
Wow! Amazing tutorial. Thank you so much! I only had to look up one small of key function because I'm on a mac, but everything was so easy to follow. Wonderful job and thank you!! P.S. You have such a calming voice, you should do a podcast!
Thank you so much for the feedback and for such kind words. You really made my day, and it's so amazing to hear that you enjoyed the tutorial so much. 😊
P.S. - Thank you for saying so. I'm not sure if I ever will do a podcast, but I will certainly consider it at some point I'm sure!
But it's not just about the technical know-how, my dude. It's also about having that creative spark, that vision to see what's possible and then making it happen. You don't just build spreadsheets, You craft digital masterpieces that make data come alive . . . I will gladly spend $5.00, thank you.
Reading this comment really made my day. Thank you so much for all of your kind words. It really means so much!
I hope you really enjoy using the password keeper, and I will do my very best to keep good videos coming. 😊
This was the best tutorial ever. Thank you. Quick question. can you make an additional tutorial to add information to your password database using the form? this is pretty good though.
Thank you so much for saying so. And what an awesome suggestion. I will add it to my list and see if I can get to it. 😊👍
Fantastic 🎉 thanks so much! Mine is perfect !!
That's so amazing to hear!! Enjoy using the template! 😄👍
Excellent tutorial! You have a new subscriber!
Thank you for subscribing, and I'm so glad you enjoyed the tutorial! 😄
Nice work, easy to follow, did miss that something needed to be populated in $D$5 or you get an na error but I figured as you do visually show it. Great stuff I'm going to apply some other bits for security but this is a fantatsic jump off point and exactly the solution I was looking for 10/10
That is so amazing to hear!! Thank you so much for leaving a comment, and I wish you only the best as you continue taking this spreadsheet forward to meet your needs. 😄👍
hi ryan, once again, you have made a very good impression on all of us with this tutorial! thanks for sharing. a couple of months ago I made a similar spreadsheet for my PW and other personal data. In this time the database as grown to about 100 rows, which makes things somewhat harder to use the dropdown list. is there any way to search the 'description' column? that would be simply awesome! have a great day, colin
Thank you so much for your kind words! It really does mean a lot and helps motivate me to keep going.
And that's a great question. If you'd like, send me an email at info@spreadsheetlife.com, and we can discuss a few ideas.
wonderful tutorial, can we also add Credit card grid values in the lookup page? how do I create that table
Thanks so much! And good question. You are welcome to send me an email, and I can try to show you how to add it.
Well..I followed your tutorial and with a tweak, I managed to get it! Thanks for your lovely tutorial!
@@spreadsheetlife
So glad you were able to get it to work! 😊👍
This is very informative, thank you. Is there a way to enter in all the data and then alphabetize the list according to the description column?
Yes. Once you've entered in all of your data, click on the down arrow box in the description column. You can then choose to sort the data by this column. I hope this helps.
Epic tutorial and one quick question too! How would I go about pulling LookUp info from two separate tabs or rather, a Database one and a a Database two?
Thanks so much!! And that's a good question. I'm sure there is more than way you could go about it, but what I would do is use the VSTACK function to combine the two datasets into one. Then I'd lookup the information from that dataset. Hopefully this helps.
wow you are a genius!
Thank you for your kind words! I'm so glad you enjoyed the content! 😊
Thank you so much!
Of course! Thank you for watching!!
Hi, first of all thanks for this tutorial. Was very easy to follow. Just had a small query, when nothing mentioned in the Notes column in the Database worksheet the result shows 0, can we somehow change this to show "None" or just get a blank cell?
I'm so glad you found this tutorial helpful and easy to follow!
That's a great question, and you can definitely update the formula to accomplish what you want to do. Just change the formula in cell G9 to the following.
=IF(VLOOKUP($D$5,Database,5,FALSE)=0,"None")
If if the VLOOKUP function returns a 0 (when there are no notes), the IF function will then return "None" as your final result. If you want a blank cell instead of "None", then changw the formula to this instead.
=IF(VLOOKUP($D$5,Database,5,FALSE)=0,"")
@@spreadsheetlife Nice!!! Thank you soo much once again!
You are super welcome!! 😄👍
Thank you!
You're very welcome! Glad you found this useful! 😊
Mr. Life your tutorial is great for some reason I cannot get that drop down box please help
If you are having problem with the dropdown box, it might be due to your range name. So I'd say, check that to see that you have it right. You can view your range names by clicking the down arrow in the Name Box.
Awesome. Ty.
Yw! 😊
Good morning, thanks for the video, I need your help because I follow steps by steps but when I tried to enter the formula on data validation, excel show me an error message that I need to type apostrophe before an equal .
I do it but I cannot see the list just show me on the cell the name, and I cannot do it anything after that
The best way for me to help would be for you to send me an email at info@spreadsheetlife.com. Attach your spreadsheet, and I can take a look at it for you.
very useful
😊👍
bro i love u thank u
So glad you found this template helpful!
Can we make this sheet as per instructions here and copy to google
Sheets . Will it work there .
Unfortunately, this will not work. Once you transfer the template to Google Sheets, you will lose the formatting on the table, and get an error for all of the formulas. I'm so sorry that's the case.
thankyu sooo much
You're very welcome! 😄👍
🤚I have a question...what happens when I have multiple Google accounts (or multiple any accounts)? Do I need to name the description with a unique name or will I be able to return multiple results? Or is this something on a more advanced password manager?
In the case of this password manager, you would need to make the descriptions unique. It would definitely be possible to build a password manager in Excel that returns multiple results with the same name, but it would work a little differently than this one.
Great, thanks for the info!@@spreadsheetlife
You're very welcome!
@@spreadsheetlife Need differently please make another video. and thank you so much
Hi there! In what way do you need it to be different?
Okay, great tutorial.. but here is the issue i have with making this thing to work. MY office Excel does not take the VLOOKUP Formula, it shows me an error, he also changes the "$D$5" to "LOOPUP!" when i chaange that back it also shows me the error. i am using office 2024, does that has something to do with it ?
Hmmm...that's strange. VLOOKUP has been around for a long time, so it shouldn't be causing you any problems. If you'd like me to take a look, send me an email at info@spreadsheetlife.com.
Same here
If you are seeing the same problem, send me an email and I can look at it for you! 😊👍
I apologize if this has been answered, but how can I password protect the file?
No need to apologize at all. That's a great question! Just follow these steps.
Go to File > Info > Protect Workbook > Encrypt With Password
Enter your password. Click ok. Enter the password again. And click ok.
I hope this helps.
can you show how to do this using pivot table?
For something like this, a pivot table is probably unnecessary since you we are just performing a simple lookup. However, I will do my best to include pivot tables in future videos so you can get some good practice in. 😊👍
How do i make this work in google sheets?
Quite a few things will be the same, but there are some key differences. More than I can explain in a comment response unfortunately. If you're interested to learn more about what you can do, send me an email at info@spreadsheetlife.com! 😊👍
Thank you!
You're welcome! 😊👍
Thank you for watching!