>>531185220
I just wanted to be lazy with the data without saving it to my own Drive.
I've just copied the IDs in column A and ranks in column B on a new sheet and used vlookup to find a match for the column array Sheet1!A:B and return the 2nd column.

I forever count my lucky stars I'm not a fucking sheetmonkey for work.