So I have this chart that has information about all the chemicals we use in
our lab, the columns have, description(chemical name and information),
manufacturer, company part #, hazards, and CAS #

From this data I am making a new chart so we can record all the chemicals
coming into our lab.
I want to enter the manufacturer's name and part # and then have excel use
these two entry's to look at the other chart and find the description,
hazards and CAS# so i don't have to type them all.

Would it be better to use some sort of vlookup (can you use this for more
than one thing), or should i use a pivot table and use a getpivotdata?

Any help would be great!