How to lookup last five values in two columns.

Hi,all
I have some data like this. I want to lookup letter "a" from column A and B, and I only want the last five results "a" appears. How can I get the results in 5 cells using functions. Thanks a lot!
a b 1
c a 2
b c 3
a d 4
b c 5
d b 6
d a 7
a c 8
a g 9
g b 10
(data)


c a 2
a d 4
d a 7
a c 8
a g 9
(results)

With your data on A1:C10 use

=INDEX(A$1:A$10,LARGE(INDEX(($A$1:$B$10="a")*(ROW($A$1:$A$10)),0),6-ROW($A1)))

Copy down and across

how-to-lookup-last-five-values-in-two-columns-vbn.xlsx