Match for column Reference 1

[binaryfingers]

Hi

I am looking for a way of being able to pull data from cell 30, with the column matching a chosen date.

Eg,

I have the dates running along row 5....as 10-Feb 11 Feb 12 Feb etc. These run from column B to column BK.

I would like a way of pulling the data out of the cell reference with the matching date adn row 30. So if todays date was 16th Feb chosen by the user, it would locate the column that had 16-feb in row 5, in this case, with the dates starting on 3rd Jan in Column B, it would return column AN.

Can you advise how to write this so it changes the column by the date lookup but maintains the row as 30.

Hope this is explainatory for how I would like to reference the cell value.

Thanks,

 

[ilses]

Supposing the date you want to llok up is in BN1

=INDEX(B1:BK30,30,(MATCH(BN1,A1:BK1,0))-1)

 

[binaryfingers]

ilses

Thanks for your quick response, it works great.