Index/Match formula returning only prioritised results

Hi all, my first post.
I am creating a spreadsheet of one farm per row, based on another sheet, which has one farm KPI per row - so multiple rows for the same farm, one for each kpi. This needs to become one row per farm, with kpi type/results/dates in columns.

I have an index and match formula that returns kpi results based on multiple criteria:
- whether they match the farm code in the appropriate row
- the KPI type in the appropriate row
- it must not be zero
- and must have been created since 2 September 2021.
My formula uses named ranges so i can expand the columns easily when the updated report comes in with additional data. Here it is:

=IFERROR(INDEX(KPIResults,MATCH(1,(FarmCodes=$A4)*(KPIs=FB$1)*(KPIResults<>0)*(DATEVALUE(KPICreationDate)>DATEVALUE("02/09/2021")),0)), "N/A")

My problem is this:
We have multiple KPIs of the same type (given in named range 'KPIs' above) and from the same Farm. However, we have only one row per farm, as that is how the analysis software requires it.
What I need to do, is return only one kpi where it meets the criteria, we have decided to prioritise by most recent date. Can anyone help with this?

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen