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

HOW TO AUTO POPULATE TEXT FROM A DROP-DOWN LIST SELECTION IN MS EXCEL // When creating fillable forms in Excel, learn to use VLOOKUP to make text populate in a cell based on a selection from another cell. In this video we populate a vendor’s address and contact information on an invoice template based on selecting a particular vendor from a drop-down list. You will learn how to set this up quickly and easily. You can then save your invoice as a PDF and send it.
__________
TEMPLATES
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
RESOURCES & GEAR
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
__________
FREE DOWNLOADS:
__________
CONNECT WITH ME:
__________
KEYWORDS: #MSExcel, how to auto populate text from a drop-down list selection in Excel, how to auto populate text from a drop-down list in Excel, how to use VLOOKUP, Excel VLOOKUP tips, link text to drop-down, creating fillable forms in Excel, create drop-down list in Excel, auto insert vendor information in invoice, invoice template Excel, Excel tips and tricks, Excel Lesson, Excel Tutorial, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:

[sccoupe]

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

[jlpayne]

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!

[wutarprish]

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!

[darkhoursofday]

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!!!

[Dan-bsud]

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

[AdrenalineConcept]

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

[anemergingartist]

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

[ridhgxr]

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

[KL-mlxw]

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!

[-am]

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!!😬😬😬

[Clarkkentuk]

You are a bloody genius Sharon! Thanks so much!

[kanwalabdulghaffar]

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

[chris-zusf]

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

[evedoston]

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

[DarkVenthos]

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!!!!

[HeadstartDelivery]

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

[NewlyNappy]

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

[funhavin]

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

[fishtailfred]

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.

[englishincontext]

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. 👍👍