Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Lookups
I'm trying to do a multiple lookup - my table looks like the following
Date Type 12 24 36 12/1/2008 1 .10 .12 .14 12/1/2008 2 .15 .18 .19 1/1/2009 1 .11 .13 .15 1/1/2009 2 .20 .23 .24 I need to lookup based on information in three cells Date 12/05/08 Type |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Lookups
"Jack" wrote: I'm trying to do a multiple lookup - my table looks like the following Date Type 12 24 36 12/1/2008 1 .10 .12 .14 12/1/2008 2 .15 .18 .19 1/1/2009 1 .11 .13 .15 1/1/2009 2 .20 .23 .24 I need to lookup based on information in three cells Date 12/05/08 - select 12/1 vs 1/1 row Type 2 months 24 select the column result would be .18 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Lookups
As long as the dates are sorted in ascending order as is shown in your
sample... Your table in the range A1:E5 Lookup values: A10 = date = 12/5/2008 B10 = type = 2 C10 = period = 24 Entered as an array** : =INDEX(C2:E5,MATCH(1,(LOOKUP(A10,A2:A5)=A2:A5)*(B2 :B5=B10),0),MATCH(C10,C1:E1,0)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Jack" wrote in message ... I'm trying to do a multiple lookup - my table looks like the following Date Type 12 24 36 12/1/2008 1 .10 .12 .14 12/1/2008 2 .15 .18 .19 1/1/2009 1 .11 .13 .15 1/1/2009 2 .20 .23 .24 I need to lookup based on information in three cells Date 12/05/08 Type |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple lookups & ifs | Excel Worksheet Functions | |||
multiple value lookups | Excel Worksheet Functions | |||
sum multiple lookups? | Excel Worksheet Functions | |||
Multiple V Lookups | Excel Worksheet Functions | |||
Multiple Lookups | Excel Discussion (Misc queries) |