Return value from a Two Variable Data Table with Dates
 

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

Return value from a Two Variable Data Table with Dates
 

=INDEX($B$2:$G$6,MATCH(I1,$A$2:$A$6),MATCH(I2,$B$ 1:$G$1))
Using the formula above doesn't work.

You're formula works OK for me.

You need to expand the range to include row 7.

=INDEX($B$2:$G$7,MATCH(I1,$A$2:$A$7),MATCH(I2,$B$1 :$G$1))

So, you'll have to expalin what isn't working.

--
Biff
Microsoft Excel MVP


"miroshak" wrote in message
...
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