lookup part description and price from different tabs

@beerbowerr:

change your title to something like 'lookup part description and price from different tabs' or some such.

see attached file - is this close to what you are looking for? choose different values for Line and Part # and have the 3 other columns populate automatically whenever you attach a file, it is also a good idea to key in some sample results so that we know what you are expecting.

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.