Data Validation and LOOKUP problem

Originally Posted by Glenn Kennedy

OK, try this one out for size...

Thank you, this almost does everything I need it to do. There is just one change I need to make to the way it sums up at the end of the table.
I need the price to be multiplied by the quantity, and when I put an Item that is not in the list I get a #VALUE! error.

Here is an example file:
Example File2.xlsx