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. 😊
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.
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 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.
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.
🤚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.
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,"")
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.
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.
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. 😊👍
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. 😊
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.
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. 😄👍
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. 😊👍
wow you are a genius!
Thank you for your kind words! I'm so glad you enjoyed the content! 😊
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.
Thank you!
You're very welcome! Glad you found this useful! 😊
very useful
😊👍
thankyu sooo much
You're very welcome! 😄👍
Awesome. Ty.
Yw! 😊
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.
bro i love u thank u
So glad you found this template helpful!
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! 😊👍
🤚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?
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!! 😄👍
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.
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 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. 😊👍