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...