List teams in rank order from list

This is probably easier than I am making it.

How do I list selected data by order of appearance in a list?

Suppose I have a named range somewhere in my workbook called "TeamsRanked".

This range contains hundreds of names. The data associated with each of these names appears in a table in the workbook in rank order. The teams are ranked in descending order according to points scored. This means that the ROW() for the HIGHER-Ranked teams will be LOWER than the ROW() for the LOWER-Ranked teams. Also, this named range is constantly being resorted as updated data is introduced.

Now...Suppose I want to monitor just a few of the names??

For example: Cells A1:A3 on a separate worksheet contain the names of the teams I want to monitor.

What formula do I need in Cell A5 to return the HIGHEST ranked of the teams in Cells A1:A3??
...in Cell A6, to return the next highest ranked.
...in Cell A7, to return the LOWEST ranked.

I tried some IF(ROW(MATCH...)) ---"is less than" ---IF(ROW(MATCH...)) formulas...and I keep getting INVALIDs in my formula palette.

Am I on the wrong track with this...???