LOOKUP value based on 2 criteria

J

Jaye

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!
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Formula For Data Summary 7
Page numbering with Merged Document and IF statements 1
If statement or lookup statement not sure 2
Divide 2 pivot table numbers 3
Add values based on text color with the criteria of a date 7
What type of "lookup" 3
Power Pivot with 2 sets of values 0
Need a lookup formula that matches 2 values and returns the 3rd va 3

Top