How to get LAST value using INDEXMATCH

[mcmuney]

I'm using this formula, which has been working perfectly... that is until it found 2 matches. How can I edit this so it shows the LAST matched value, instead of first???

=INDEX('Q3'!$F$1:'Q3'!$F$332,MATCH(K22,'Q3'!$AB$1:'Q3'!$AB$332,0))

Thanks.

 

[Marcelo Branco]

Try

=LOOKUP(2,1/('Q3'!AB1:AB332=K22),'Q3'!F1:F332)

M.