Data Validation and LOOKUP problem

I have a table that has a data validation drop down list. When I pick an Item, the information from another table is transferred over. Everything is working except for when I manually enter a Item that is not in my item list, all the cells in the table display #N/A. I attached an example file to this thread.

When I enter an Item that is not in my Item list, I want column D in that row to have the value "Unit" and Columns E,F,G to display nothing.
You can see what I am trying to explain in my example file.

Thank you

Example File.xlsx

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