Index, match, duplicates in array - how to pick up the last/bottom line

Hi
I have tried to find solution for my problem but so far no luck. My formula with defined names is this

=INDEX(zflexSTATdelDte,MATCH(KHL_AUK_ID,zflexAUKid,0))

If in array there are duplicates it always picks up the first line. Its great as thats what I need. But now I need exactly the same formula but now I would like it to pick up the last line from array. That is if there are duplicates.
Can someone advise me how to change the formula. I will give an example

---zflexAUKid------------zflexSTATdelDte
180081418310------------ 14/04/2011
180081418410------------ 11/04/2011
180083049910------------ 01/03/2011
180083049910------------ 01/03/2011
180083049910------------ 01/04/2011
180083066010------------ 29/03/2011
180083064710------------ 09/04/2011

So as you can see in array column there are x3 duplicates highlighted in red. Current formula picks up the date in green. The new formula that I'm after should pick up the date in blue.


Any ideas?

Kind regards,
Rain


So if in array zflexAUK there are some duplicates

Doing this will cause problems when there is now match. Instead of saying #N/A it picks up a one random date and then uses it everywhere where it should be #N/A.
The dates it does pick up are wrong as well.

Any other ideas?

If there are duplicate cells in array column then the bottom line always has the latest date in the index column. By that I mean that the last line has always date furthest into the the calender year i.e. the dates for these duplicate lines in index column are in ascending order. The date may be either in past or or future.

I hope this helps.

*bump*bump*

*bump*bump*

*bump*bump*

bump*anyone?