Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
Lookup on 2 Values | Excel Worksheet Functions | |||
Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
LOOKUP VALUES | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |