Enter a product on Sheet 1. You want a VLOOKUP Formula to grab the description from a Lookup Table on Sheet 2. However, if the product is missing from Sheet 2, you want Excel to stop, ask for the correct description, and then add that to the Lookup Table so future entries for this product will get the proper description.

Today, Episode #1868 uses a VBA Macro to achieve this result. The video is based on the question originally posted here: ‘Create a Dynamic Unique List that Updates Automatically‘. You can copy the VBA code and read the ‘How-To’ information from that link so you do not have to type the code.

LE10_180WP

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

And if you’re looking to upgrade to Excel 2013, the check out:

InDepth_180WP

Microsoft 2013 InDepth” – by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013.

VBA and Macros Excel 2013 by Bill Jelen and Tracy Syrstad

Use Excel® 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! You’ll discover macro techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful and useful.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!