Hello,

I am a fairly basic excel user, and I am looking for some assistance.
I have made a table in excel of our main inventory products, with columns such as part number, description, vendor, and price.
We would like to be able to use this workbook/worksheet as our main resource to be used in the quoting of future projects. Is there any way to have a new project workbook talk to the main parts listing? I.e if I were to type in the part number, is it possible for the description, vendor, and price, auto fill?

We have a multitude of projects, with varying parts needed, and we are trying to cut out the man hours of copying all the data.

I hope that explains what I am looking for.