Lookup with two lookup values

[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.

 

[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