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???
Thanks.
Code:
=INDEX('Q3'!$F$1:'Q3'!$F$332,MATCH(K22,'Q3'!$AB$1:'Q3'!$AB$332,0))
Thanks.