Return value from a Two Variable Data Table with Dates

  • Thread starter Thread starter miroshak
  • Start date Start date
M

miroshak

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
 
=INDEX($B$2:$G$6,MATCH(I1,$A$2:$A$6),MATCH(I2,$B$1:$G$1))
Using the formula above doesn't work.
Click to expand...

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.
 
Back
Top