Hi,
I have the following formula;
=INDEX('Rp#7-Milk-Production-Summary'!$AN$14:$AN$25,MATCH($G15,'Rp#7-Milk-Production-Summary'!$H$14:$H$25,0))
I need to add an IF statement to the Match part of the function so that it returns the match that is within the Month.
Column G has dates for the 365 days of the year
Columnn 'Rp#7-Milk-Production-Summary'!$H$14:$H$25 has 12 rows for each month of the year in this format [$-C09]mmm-yy;@
Any helpers ??
I have the following formula;
=INDEX('Rp#7-Milk-Production-Summary'!$AN$14:$AN$25,MATCH($G15,'Rp#7-Milk-Production-Summary'!$H$14:$H$25,0))
I need to add an IF statement to the Match part of the function so that it returns the match that is within the Month.
Column G has dates for the 365 days of the year
Columnn 'Rp#7-Milk-Production-Summary'!$H$14:$H$25 has 12 rows for each month of the year in this format [$-C09]mmm-yy;@
Any helpers ??