Show the current value

[Param]

Hi, Please guide me how to use formule for the below function;

I have 2 worksheets. At worksheet2 I will enter the latest number of students by term. e.g
cell D40 (number of students from Jan-Mac),
cell G40 (number of students from Jan-Mei)
cell J40 (number of students from Jan -Oct)

My question how to display the latest population of students (pick up) from D40/G40/J40) on cell B2 at worksheet1. Thanks in advanced

 

[Bob Phillips]

=IF(MONTH(TODAY())>5,Sheet2!J40,IF(MONTH(TODAY())>3,Sheet2!G40,D40))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi, Please guide me how to use formule for the below function;

I have 2 worksheets. At worksheet2 I will enter the latest number of students by term. e.g
cell D40 (number of students from Jan-Mac),
cell G40 (number of students from Jan-Mei)
cell J40 (number of students from Jan -Oct)

My question how to display the latest population of students (pick up)

from D40/G40/J40) on cell B2 at worksheet1. Thanks in advanced

 

[Aladin Akyurek]

Although a bit fancy...

=LOOKUP(9.99999999999999E+307,IF(MOD(COLUMN(D40:J40)-CELL("Col",D40)+0,3)=0,
D40:J40))

Hi, Please guide me how to use formule for the below function;

I have 2 worksheets. At worksheet2 I will enter the latest number of students by term. e.g
cell D40 (number of students from Jan-Mac),
cell G40 (number of students from Jan-Mei)
cell J40 (number of students from Jan -Oct)

My question how to display the latest population of students (pick up)

from D40/G40/J40) on cell B2 at worksheet1. Thanks in advanced