Within a table, I am looking down a list where I am likely to get more than one match for figure upon which I am searching. Things like VLOOKUP, MATCH, will find the first occurance, but is there a way of specifying the nth occurange of X within the list? For example
A B
12 Dave =VLOOKUP(22,A1:B8,2,TRUE) =Andy
22 Bob =MATCH(22,A1:A8,0) =2
50 Stuart
22 Andy
45 Sarah
71 Blah
83 Steve
22 Jason

These exact matches return the first occurance of 22 (there are 3), but how can I say find me the 2nd (or 3rd) occurance of 22?

Thanks!