Dynamic Form in Excel

I added a validation list to the tab which you pick a product off. The next three columns get pulled in from the inventory list. These are filled by VLOOKUP.

I can make this prettier (make the #N/A's disappear) with an if then statement, but the basic problem is solved. I also made a print_area on the order form.

A second if then statement could also make the item show up as Backordered if the available quantity was < than the amount ordered.

How's that?