Excell formula to find number 3 in column ah, then display the text from the same row in column A

I have a large spreadsheet with approximately 20 columns and 100 rows. Each column has data from a competition, some rows are text, some are numbers that using a formula to rank 1 - 100.

I have another column A on page 2, for trophy lists. So I need a formula that will:

1. On page 2, I want to put 3rd place in Column A Row 1. I need column B1 to search on page 1 column AH to find 3rd place in the rank and reflect the text from that row in column A on page 1.

I know this is confusing, and I can attach a picture of the worksheet if needed.

I'm not very excel savy, but ive made it this far with the sheet and have hit a wall. Any help will be appreciated.