# TYD Data from Monthly Data Input

#### Hayley_A

##### New Member
I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it.

Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that would pull the most recent months data through to the report worksheet?

The data I'm trying to pull through is "Live Vacancies".

So for example the monthly data would be:
 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Live Vacancies 3 5 4 7 3 9 10 3 5 2 7

<tbody>
</tbody>

I want a cell in the report worksheet which would pull through the most recent value depending on when the report is being used. So if it is opened in May then the number of live vacancies in the report would come through as 3 and so on for whichever month the report is opened.

I would assume you could use the =today() function then change the format of the cell to "mmm" and use the =IF function in conjunction somehow?

Any help would be great!

Ta

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### mrshl9898

##### Well-known Member

=INDEX(\$B\$2:\$M\$2,1,MATCH(TEXT(TODAY(),"Mmm"),\$B\$1:\$M\$1,0))

#### Hayley_A

##### New Member
This is perfect, thank you!