How To Auto Populate Text From A Drop-Down List Selection in MS Excel - Create Fillable Forms 

I appreciate you getting to the point no extra fluff, but the best part is you take your time explaining and showing how to do it. Thank you!

This is by far the best vlookup explanation I have ever seen. Sharon makes it very easy to understand. thank you, SHARON !!!

After tedious and numerous excel video search, finally found this! this is exactly what I'm looking for. The right key word is Auto-populate! Thank You Sharon for this video. Very helpful!

This was EXACTLY what I was looking for. Very well explained and easy to follow. I'm using it to make a macro counter and calculator for a keto diet based on a spreadsheet of foods I've made. It worked perfect!!!

Sharon, you LEGEND!!! Thank you for your clear, concise and to the point video. This was near perfect a real-scenario for me.

Hi your training was excellent, much better than other videos regarding the same topic. Thank you very much!!

THANK YOU THANK YOU THANK YOU!!! I have been fighting with this all morning trying to make this work and you solved my issues in 5 mins. You are a saint!

omg a few hours later I finally found what I was looking for, THANK You so much you just helped me simplify my recipe building process w cost inputs your the best!!😬😬😬

Excellent video. Clear, and very well presented. There are others I've watched on the same subject where the channel creators hum and ha, are constantly clicking for no apparent reason and I'm left feeling irritated and confused. Not so with this demonstration. So, many thanks for the video. It's much appreciated. 👍👍

OMG, I have been searching for the solution to a problem just like this for well over an hour, Thank you for posting this video! As always, its hard to find a solution when you don't know how to describe your problem in the vernacular of the software.

This is genius. I have been looking for this. Thank you so much for explaining it to the point !!!

So happy after searching long I finally got the formula that I wanted

This video helped me do that exact thing in google sheets, that doesnt have the vlookup window to help due to your explanation! THANK YOU ALOT!!!!

I looked at about 7 different videos on this topic and none made sense. This one was perfect and easy to follow. The main different, the rest were all taught by men. LOL! Lesson learned. Thank you!!

The most detailed video ever. Thank you a million for this.

You are a bloody genius Sharon! Thanks so much!

I love you take your time and systematically walk through each step!

Thanks Sharon. I have been looking for a couple things you show here for a while. Thank you!!

Excellent tutorial…excellent trainer

You helped me solve a huge problem I was having with my excel spreadsheet. Thank you so much!

Exactly what I needed Sharon! Thank you, this is a life saver :), Also, I think your voice is radio show quality....

This was such a good video, it was exactly what I was looking for. Thank you!!

Lol I just realized you put Shawn Spencer and Psych Industries I LOVE IT

Great help thanks was trying this from other places byt yess i did it. Thanks to you

Thank you, Sharon. I had the similar task to do, so helped a lot.

WELL I HAVE LEARNT SO MUCH OF YOU MANY THANKS FOR YOUR TIME AND KNOWLEDGE

saved my life. easy to follow along. Thanks for a very useful content for a beginner like me!

Perfect, exactly what i need for my quote form and my gantt chart. thank you for sharing your knowledge Sharon. if you need to know anything about renovations just ask me. thank you again.

Perfectly explained, thank you so much!!

Perfect, thank you so much, I've managed to do what I needed from just one video, amazing!

THANK YOU! YOU ARE AN ANGEL!!

Can't thank you enough Ma'am, u just gained one more subscriber 🙏

Fantastic video, very easy to follow. Thanks!

Awesome video, this helped me immensely. Thank you! I also love the Psych reference.

Awesome . Thank you so much for ur Great and useful Videos 🙏 honestly I did not have the opportunity to to go to school or learn things in my childhood and now I'm a refugee and waiting for resttlement and I'm trying to learn Microsoft office and Excel for my Future I hope someday I can have a job as an Excle expert.😊

Thank you for this very informative video. 😇❤️

perfect explanation

Thank you so much for making this look so easy! 😃

Thanks Sharon!

Hi Sharon ! A Big Big Big Thank you for this tutorial. :)

Excellent method straight to the point... Thanks

Very good. I can numerous ways of using that method other than just for invoices.

Gave me an idea on how to make a school card system that generates various grades depending on the name of students and their corresponding year, all thru excel only... So for this, Thank you very much.

Your amazing Sharon!

Thank you so much for this. I gained another excel knowledge. :-)

Excellent presentation. Thank you!

This is exactly what I was looking for! Thank you!

Is there a way to do this but instead of a dropdown list but with checkbox list; they check a few boxes and it auto-populates a paragraph with 3 sentences based off those 3 lines of text that they checked next to?

Amazing video! But did anyone catch that she is a fan of the show Psych!!

Excellent video!

Thanks a lot Sharon

OMG! I love you!!!! Thanks for sharing!!!

This is fantastic. Thanks. I have a started a quote sheet by following this process. Now I have a cell that needs to say If this, then 0 and if that, then doe a vlookup. When I try this, I get a correcting saying I am putting too much in the cel.

Exactly what I needed Sharon! Thank you, this is a life saver :)

Great thanks. This is exactly what I need

Love your tutorials. Thanks.

Thank you very much, dear teacher.

Thanks!

Thank you for your help!!

Great presentation. I was getting real frustrated because my formula wasn't working. Had to find additional resources that told me the "source" needs to be pulled from the leftmost column (or first column) in a table. The

This is exactly what I needed, thank you!

Thank you. This helped a lot.

that is exactly what i was looking for! thank you so much ! the video was perfect , very easy to understand and also so short! saving time and learning new things i never heard of you but i instantly subscribed and liked your video

Excellent! To the point.

Thanks for the info 👍

Thank you ☺️

Very good video showing the steps. I had to watch it a few times to get it, but that's me not your instruction.

Thank you so much for sharing!

Beautiful lesson, 😍😍😊

Thank you!

Life Saviour thank you so much!!!!!

Sharon, thank you for the video. I can't seem to get my drop down list to update once I've added rows to my selection data.

Thank you so much. It make my life easy

That was really great but if I want to do rows, but put the pull down in but don't want N/A to show up. How do I keep N/A from displaying by default?

Thank You! Please explain how to pick and drop data in a cell in excel to another cell.

Thankyou so much ❤️

Thank you so much.

Best explanation 👌

Not really helpful, I wanted to know how I can make it so that a dropdown list has by default a name inside it when I insert a new row.

Awesome vid simple and to the point!!! ;))

This is what I needed! Thank you very much :)

Thankyouuuuuuuu!!!!!!❤

Its so easy to understand, thaks. How put formula to auto fill wholesale, retail and mrp in different Calum after select a product from dropdown. Please help

thank you so much

Thank you so much for your effort. A great tutorial.

You've made my day. Thanks for the excellent tutorial. Question though... How can I... if need be... overwrite the cells containing the drop down list with regular text?

I have my first dropdown with 2 selections: Standard Glass and Tempered glass. I have another dropdown where the user can select the width of the glass. My problem: the second dropdown values need to change depending on what kind of glass was selected in the first dropdown. Please provide the solution

When I attempt to make drop down I get a promt the list source must be delimited list or a reference to single row or column. Not allowing me

I have now added the client detail to auto fill in quote. How can i auto fill products and cost per client in quote as all clients have different costs on products

hello. thanks for your time and efforts and for great content. is that possible in MS word ?

it was so helpful, thank you, I used in a tab I named payroll getting the data from another tab tha I named data it worked perfect!, now I'm stock trhying to get the total hrs from another tab I named week containing all people in the company some worked some didn't, is there a formula that let me get the total hrs only from people who worked? Thank you in advance for your reply Sharon kind regards

When I set up Data Validation the drop down still has blanks even tho 'Ignore Blank' has been checked. Why does it work for you but not me?

Thanks a lot , it was really helpful :)

Your videos are so helpful. Thank you! Do you have another video on how to print multiple selections from these dropdown list forms?

Ive made a macro to copy the customer details on an invoice form to a customer list (New_Customer) however the efficiency of this is only usefull if we can populate the main cell still from a list. I'd love it if you have a work around for getting autocomplete (Normally on same column data) on the customer name cell, to come from the customer list, but still allow the new entry so new customers can be added still with the macro. All I can think of is hiding another copy of the customer name list in the colum below the invoice form so autocomplete works

Thanks ma'am for your great video 🙏❤️ I just have a query...can this autopopulation be really automatic so that just by entering the Client name or code no. the address n phone no.etc. is automatically copied from the assigned cell/s by linking those cells to the name cell 🙏 please let me know as I am trying to analyse my Bank statement each row to Account n then automatically generate the Group Head like INCOME, EXPENSES,ASSET, LIABILITY,etc. 🙏😭

Thank you for making this tutorial video, I am struggling with how to deal with same name people in the drop down list? Excel automatically combines all duplicate values in a drop down list. I have tried using a number in front of a name to make it unique, the drop down does show as unique entries but then the vlookup function is hard to implement. Still stuck and haven't found a solution. :((

Thankyou madam for saving me life

Hi, data validation not working 2007 it does not pick source col from other sheet

Is there a drawback to turning a datasheet/database into a table since I would line to get be able to pull customers by their phone numbers as I create new invoices? Is there a limit to a table versus a nun table database? Hope make question makes sense..