Display Data For Today's Date

Camilla1980

New Member
Joined
Mar 22, 2018
Messages
13
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,317
Office Version
365
Platform
Windows
Something like
=INDEX(Sheet1!F2:F33,MATCH(TODAY(),Sheet1!A2:A33,0))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,317
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,077,990
Messages
5,337,585
Members
399,156
Latest member
RaudMees

Some videos you may like

This Week's Hot Topics

Top