Need formula to return certain cell based on the current date

Hello all!

I am sure there is a simple solution to this that I'm over complicating. I need a formula that returns the number in the cell that corresponds to that days date. Basically, if today is 9/27/16, and my table looks like this:

	9/8/16	9/22/16	10/6/16	10/20/16	11/3/16	11/17/16
Purple	8	11	14	17	20	23
Green	10	13	16	19	22	25
Yellow	12	15	18	21	24	27
Blue	14	17	20	23	26	29

I want my other chart to populate with the correct numbers based on the date ranges provided (for 9/27, the numbers would be from column 9/22, any date between 10/6 and 10/20 would return the numbers from 10/6, etc.):

Current Colors
Purple
Green
Yellow
Blue

Any help is appreciated!

Thank you,
Meg

It would have helped if you had told us which cells you are using for your data. Assuming your main table occupies the range A1:G5, and that your (lower) colour purple is in cell A11, then you can use this formula in cell B11:

=IFERROR(INDEX($B$2:$G$5,MATCH(A11,$A$2:$A$5,0),MATCH(TODAY(),$B$1:$G$1)),"")

Then copy this formula down.

Hope this helps.

Pete

Perfect!

Thanks so much!

Meg

Originally Posted by Glenn Kennedy

Is this what you wanted:
=IFERROR(INDEX($B$2:$F$5,MATCH(B9,$A$2:$A$5,0),MATCH($C$8,$B$1:$F$1,1)),"")
Where C8 is the date to be searched and B9 to b12 is a list of the colours.

Perfect!!

Thanks,
Meg