HOW TO AUTO POPULATE TEXT FROM A DROPDOWN 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 dropdown 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
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
RESOURCES & GEAR
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ Camera: https://amzn.to/39KvpQA
✦ Live Stream Tool: https://amzn.to/2VFJyID
✦ PresenterMedia: https://shareasale.com/r.cfm?b=417324...
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!
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgibin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... to signup for my email list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn:   / sharonsmithhr  
Twitter:   / sharonsmithhr  
__________
KEYWORDS: #MSExcel, how to auto populate text from a dropdown list selection in Excel, how to auto populate text from a dropdown list in Excel, how to use VLOOKUP, Excel VLOOKUP tips, link text to dropdown, creating fillable forms in Excel, create dropdown 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:
➤Creating Fillable Forms:    • How To Create A Fillable Form In Micr...  

➤PowerPoint Tutorials for HR:    • PowerPoint Tutorials  

➤ Excel Tutorials for HR:    • Microsoft Excel Tutorials  

➤ Excel Quickies (Around 2 Minutes):    • Excel Tips & Tricks  

➤ Word Tutorials for HR:    • Microsoft Word Tutorials  

➤ Welcome | About Me:    • Playlist