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!)
@spreadsheetlife
8 ай бұрын
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.
@tinytoons2517
4 ай бұрын
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.
@spreadsheetlife
4 ай бұрын
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. 😊
@Dogewisperer
5 ай бұрын
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.
@spreadsheetlife
5 ай бұрын
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. 😊👍
@colinhuntley9729
29 күн бұрын
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
@spreadsheetlife
28 күн бұрын
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.
@shredding1000
Ай бұрын
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?
@spreadsheetlife
Ай бұрын
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.
@pesmechanic2000
9 ай бұрын
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?
@spreadsheetlife
9 ай бұрын
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.
@AlHR23
2 ай бұрын
Excellent tutorial! You have a new subscriber!
@spreadsheetlife
2 ай бұрын
Thank you for subscribing, and I'm so glad you enjoyed the tutorial! 😄
@AeroaidsCorporation
8 ай бұрын
wonderful tutorial, can we also add Credit card grid values in the lookup page? how do I create that table
@spreadsheetlife
8 ай бұрын
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.
@AeroaidsCorporation
8 ай бұрын
Well..I followed your tutorial and with a tweak, I managed to get it! Thanks for your lovely tutorial! @@spreadsheetlife
@spreadsheetlife
8 ай бұрын
So glad you were able to get it to work! 😊👍
@SoorajVarrier777
4 ай бұрын
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?
@spreadsheetlife
4 ай бұрын
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,"")
@SoorajVarrier777
4 ай бұрын
@@spreadsheetlife Nice!!! Thank you soo much once again!
@spreadsheetlife
4 ай бұрын
You are super welcome!! 😄👍
@therealnatureboy26
5 ай бұрын
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
@spreadsheetlife
5 ай бұрын
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. 😄👍
@gaetanolaveglia1484
16 күн бұрын
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
@spreadsheetlife
15 күн бұрын
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.
@venkyraju21
2 ай бұрын
Can we make this sheet as per instructions here and copy to google Sheets . Will it work there .
@spreadsheetlife
2 ай бұрын
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.
@BigBrownMonke
14 күн бұрын
Thank you so much!
@spreadsheetlife
14 күн бұрын
Of course! Thank you for watching!!
@Backindemand
5 ай бұрын
Mr. Life your tutorial is great for some reason I cannot get that drop down box please help
@spreadsheetlife
5 ай бұрын
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.
@sweetc1220
8 ай бұрын
🤚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?
@spreadsheetlife
8 ай бұрын
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.
@sweetc1220
8 ай бұрын
Great, thanks for the info!@@spreadsheetlife
@spreadsheetlife
8 ай бұрын
You're very welcome!
@sishorif2202
3 ай бұрын
@@spreadsheetlife Need differently please make another video. and thank you so much
@spreadsheetlife
3 ай бұрын
Hi there! In what way do you need it to be different?
@sanho6030
Ай бұрын
Thank you!
@spreadsheetlife
28 күн бұрын
You're welcome! 😊👍 Thank you for watching!
@fabulousfaheem5185
3 ай бұрын
wow you are a genius!
@spreadsheetlife
3 ай бұрын
Thank you for your kind words! I'm so glad you enjoyed the content! 😊
@randyholsapple8061
25 күн бұрын
I apologize if this has been answered, but how can I password protect the file?
@spreadsheetlife
24 күн бұрын
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.
@tootinscootin1597
9 ай бұрын
Awesome. Ty.
@spreadsheetlife
9 ай бұрын
Yw! 😊
@brandcell360
5 ай бұрын
very useful
@spreadsheetlife
5 ай бұрын
😊👍
@CarolTrieu-f2t
2 ай бұрын
can you show how to do this using pivot table?
@spreadsheetlife
2 ай бұрын
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. 😊👍
@mohammedaminedouddouh4970
10 ай бұрын
bro i love u thank u
@spreadsheetlife
10 ай бұрын
So glad you found this template helpful!
@Meehaly
3 ай бұрын
thankyu sooo much
@spreadsheetlife
3 ай бұрын
You're very welcome! 😄👍
@brittrayburn9642
4 ай бұрын
Thank you!
@spreadsheetlife
4 ай бұрын
You're very welcome! Glad you found this useful! 😊
Пікірлер: 65