date change and column change

[gdgosse]

Hi

I have a simple spreadsheet with two tabs, one called 'data' with dates along the top and values below and a 'summary' sheet. On the summary sheet I would like to be able to enter, for example sake, April and the formula to return the april value and then when I change the date to May on the summary sheet the cell returns the may value from the data tab.

Can someone please help

Cheers

 

[Jared_8878]

=INDEX(data!A1:N2,2,MATCH(A1,data!A1:N1,0))

if adjustable date is in summary A1 and above formula is in A2


dates are in row one of data tab, numbers are in row 2 of same tab

 

[Jared_8878]

Alternatively you could use
=OFFSET(data!A1,1,MATCH(summary!A1,data!A1:N1)-1)