This is (probably) what you need:
http://www.contextures.com/xlFunctio...ml#IndexMatch4
It is a type of double-lookup.
Regards,
Ryan--
--
RyGuy
"LAB" wrote:
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!