lookup part description and price from different tabs

Sorry about the Title. Yes this is exactly what I was trying to do Thank you.

Is there a way to set it up so I can just Key in the Line and Part number and not have to select it from a drop down? Thanks again for all of your help

columns A and B will allow you to enter a Line and Part value in the respective fields without forcing you to select one from the dropdown list. however, if an incorrect value is entered, xl will scream.

I cant seem to get this to work on my large sheet. I am not sure how to correctly built the list for line and part.