Display Data For Today's Date

[Camilla1980]

Hi there,

I was wondering if someone could offer a novice a helping hand?

I'm pulling together a dashboard to display, amongst other things, the cumulative daily % variance of actual v target.

I have the days of the month in A2-A33 and the actual cumulative +/- % in F2-F33.

The only thing I want to display on the dashboard is the daily cumulative % as of that day (from column F) and this would be shown in H2.

Any help would be really appreciated!

Thanks in advance

Camilla

 

[Fluff]

Something like
=INDEX(Sheet1!F2:F33,MATCH(TODAY(),Sheet1!A2:A33,0))

 

[Camilla1980]

Works beautifully - thanks so much for the super speedy response, Fluff!

 

[Fluff]

You're welcome & thanks for the feedback