LOOKUP value based on 2 criteria
 

I hope someone can help me. I have 2 databases, one that records order info,
and the other that records shipping info. After pivoting the data in the
shipping database, I want to transfer the total quantity shipped against a
particular order to the order database. However, one order # can have several
part #'s associated with it. Is there a way to lookup Order # (Column A) AND
Part # (Column B) to retrieve the correct data for the specific part?

Please help!

Jaye,

Here is an example

=INDEX(C1:C10,MATCH(1,(A1:A10="Bob")*(B1:B10="Car" ),0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jaye" wrote in message
...
I hope someone can help me. I have 2 databases, one that records order
info,
and the other that records shipping info. After pivoting the data in the
shipping database, I want to transfer the total quantity shipped against a
particular order to the order database. However, one order # can have
several
part #'s associated with it. Is there a way to lookup Order # (Column A)
AND
Part # (Column B) to retrieve the correct data for the specific part?

Please help!