I have a list of names in Column A and a list of scores in Column B. They are unsorted.

In Column C I would like to list the names, sorted by descending score.

My formula is returning #VALUE's, I think because the last few rows in Column A and B contain an empty string (""). (The number of names over time will change over time, but it will never exceed 100.)

How can I edit the formula to account for this? I've tried all sorts of things and can't figure it out. If it helps, I do have a cell that stores the number of non-blank rows in Column A and B.

Formula:

=INDEX(A$1:A$100,MATCH(LARGE(RANK(B$1:B$100,B$1:B$100)+ROW(B$1:B$100)/1000,ROWS(C$1:C1)),RANK(B$1:B$100,B$1:B$100)+ROW(A$1:A$100)/1000,0))