ExcelBanter - Lookup with two lookup values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup with two lookup values (https://www.excelbanter.com/excel-discussion-misc-queries/200874-lookup-two-lookup-values.html)

Lookup with two lookup values

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.

Lookup with two lookup values

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

"KimC" wrote:

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.