Hi All, I have been trying to work this out myself but I really do need help
Below is a table I made to work out the kg/DM(Dry matter in the grass) by just inserting the CM and the Date measured.
Have tried index formular but get #N/A error =INDEX($F$2:$O$6,MATCH(1,INDEX(($F$1:$T$1=A2)*(($D$2:$D$6<=B2)*(($E$2:$E$6>=B2)+($E$2:$E$6=""))),0,1),0))
Below is a table I made to work out the kg/DM(Dry matter in the grass) by just inserting the CM and the Date measured.
Have tried index formular but get #N/A error =INDEX($F$2:$O$6,MATCH(1,INDEX(($F$1:$T$1=A2)*(($D$2:$D$6<=B2)*(($E$2:$E$6>=B2)+($E$2:$E$6=""))),0,1),0))
CM Measured | Measured Date | KG/DM | Season Start Dates | Season End Date | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 |
9 | 24/01/2022 | #N/A | 23/09/2022 | 15/11/2022 | 3250 | 3130 | 3010 | 2880 | 2750 | 2620 | 2470 | 2320 | 2150 | 1980 |
10 | 9/02/2022 | 15/11/2022 | 22/12/2022 | 3930 | 3740 | 3550 | 3350 | 3150 | 2960 | 2750 | 2540 | 2330 | 2110 | |
22/12/2022 | 21/03/2022 | 4610 | 4340 | 4080 | 3820 | 3560 | 3290 | 3030 | 2770 | 2500 | 2240 | |||
21/03/2022 | 21/06/2022 | 4210 | 3970 | 3720 | 3480 | 3240 | 3000 | 2750 | 2510 | 2270 | 2020 | |||
21/06/2022 | 23/09/2022 | 3050 | 2890 | 2730 | 2580 | 2420 | 2260 | 2100 | 1940 | 1780 | 1620 | |||