How to Make an Excel Order Form

✅ Get the sample Excel file to follow along ► https://myctx.link/order

🔵 See how to make an Excel Order form in this step-by-step video. Make product drop down lists, and add a VLOOKUP formula to find the price for the selected product. At the top, make a Customer drop down, with formulas to find the customer address info.

💡 Related Links 💡
Create an Excel Order Form ► https://myctx.link/order
More Excel Tips & Videos ► https://myctx.link/TipsXL

🔴 Related Excel Videos 🔴
Excel Order Form-Quick Demo ►    • Excel Order Form Quick Demo  
VLOOKUP - Find Product Price ►    • Find Product Price with Excel VLOOKUP  
VLOOKUP - Product Price for Quantity ►    • Find Product Price for Quantity with ...  

✅ Excel resources I recommend ► https://myctx.link/xlpick

🔶 Instructor: Debra Dalgleish, Contextures Inc.
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips

⏰ Video Timeline ⏰
00:00 Intro
01:00 3 Sheets
02:26 Excel Tables
03:27 Named Ranges
05:34 Start the Order Form
06:21 Add the Headings
06:58 Product Drop Downs
07:43 Price Lookup
08:59 Add VLOOKUP
10:09 Row Total
11:26 Grand Total
12:06 Add Formatting
13:01 Customer Drop Down
13:49 Customer Lookup
15:15 Combined Lookup
17:44 Final Formatting
18:34 Get the Sample File