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.
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.
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 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.
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. 😄👍
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.
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,"")
🤚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.
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.
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.
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.
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.
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. 😊👍
Great tutorial! Just followed your instructions and it works perfectly. Thanks so much.
That's awesome! I hope you love using the workbook! 😊
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.
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. 😊
Fantastic 🎉 thanks so much! Mine is perfect !!
That's so amazing to hear!! Enjoy using the template! 😄👍
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. 😊👍
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 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.
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. 😄👍
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.
Excellent tutorial! You have a new subscriber!
Thank you for subscribing, and I'm so glad you enjoyed the tutorial! 😄
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!! 😄👍
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! 😊👍
Thank you so much!
Of course! Thank you for watching!!
🤚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?
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.
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.
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.
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.
wow you are a genius!
Thank you for your kind words! I'm so glad you enjoyed the content! 😊
Thank you!
You're very welcome! Glad you found this useful! 😊
Awesome. Ty.
Yw! 😊
very useful
😊👍
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.
thankyu sooo much
You're very welcome! 😄👍
bro i love u thank u
So glad you found this template helpful!
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. 😊👍
Thank you!
You're welcome! 😊👍
Thank you for watching!