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