tryin to perform a type of vlookup

[finley]

how can I lookup a cell value one sheet and then on another sheet find the last time that value ( for ex: 345, which will make several appearances ) appears and return the 7th cell in the row

A1 A2
345 look up the number to the left and go find the last time it appears in the other sheet and return the 7th cell's value
409
874
258



other sheet

A1 A2 A3 A4 A5 A6 A7
874
345
258
345
409
345 C

Thank You,
BD

[protonLeah]

=LOOKUP(2, 1/(ISNUMBER(SEARCH(Sheet2!$A$1:$A$6, A1))), Sheet2!$G:$G)