Lookup with two lookup values

K

KimC

I have two sheets one sheet I heap of information
For example something like this:

A B C
1 CODE QTY DATE
2 1212 2 1/09/2008
3 2323 12 26/08/2008
4 3434 5 1/09/2008

On another sheet I want to in B2 find the QTY when you match the Code (in
column A - see below) & Date (in Row 1)

A B
1 1/09/2008
2 3434

Please help with any suggestions.
 
J

JMB

If your table is in Sheet1!A1:C4, try:

=INDEX(Sheet1!$B$2:$B$4,MATCH(1,(Sheet1!$A$2:$A$4=$A2)*(Sheet1!$C$2:$C$4=B$1),0))

array entered using Ctrl+Shift+Enter
 

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

Top