Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to return the value from I created a formula in cell I3:
=INDEX($B$2:$G$6,MATCH(I1,$A$2:$A$6),MATCH(I2,$B$1 :$G$1)). I would use cells I1 as the input for column A data and I2 as the input for row 1 data. Using the formula above doesn't work. Also there would be an occasion where some of the input dates in cell I1 or I2 could be inbetween different dates in the data table and not be exact. 11/1/2008 12/1/2008 1/1/2009 2/1/2009 3/1/2009 4/1/2009 11/1/2009 1 2 3 4 5 6 12/1/2010 1 1 2 3 4 5 1/1/2011 1 1 1 2 3 4 2/1/2011 1 1 1 1 2 3 3/1/2011 1 1 1 1 1 2 4/1/2011 1 1 1 1 1 1 -- Any help would be greatly appreciated. Miroshak |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Get Formula from 2 variable Data Table | Excel Discussion (Misc queries) | |||
one variable data table | Excel Worksheet Functions | |||
How do I create a one variable data table? | Excel Discussion (Misc queries) | |||
How do I create a one variable data table? | Excel Discussion (Misc queries) |