Help for IF function

[Juniad]

Hello everyone,
Thank you for taking the time to review the file.

 

[vletm]

Juniad​

One sample ...

 

[Juniad]

Thanks Vletm,
In my previous post, I mentioned dummy data, but for real-time data, this approach does not work.

Something like this is required.

 

[bosco_yip]

Maybe,

D8, formula copied across right:

=IF(D4>=$D$2,OFFSET($D$6,,MONTH(D4)-MONTH($D$2)),"")

 

[vletm]

Juniad​

Even any sample or dummy data should reflect with real-time data.

 

[Juniad]

Maybe,

D8, formula copied across right:

=IF(D4>=$D$2,OFFSET($D$6,,MONTH(D4)-MONTH($D$2)),"")

View attachment 85132

Perfect. Thank Bosco <3

 

[Peter Bartholomew]

= IFERROR(
INDEX(label, 1 + DATEDIF(criterion, dateRange, "m"), "")),
"")