Welcome to the 30th Easy Excel tutorial. Today I want us to do something new with something we already know. We're going to create a simple order form just to see how dynamic Excel can be.
Using dropdown validation, and either vlookup or index match, we can really make this form interactive and error free.
Remember to checkout the Resources section below for associated downloadable content, JSFiddle links, and other resources. Watch the video and follow along!
Download the associated Excel Spreadsheet here: Download