At a basic level, you could use case number 2 in the following post. Instead of pointing the lookup at the entire table, you would point it at your sorted query. This works at a basic level, but gets complicated if you start to have ties. All depends on how you would expect ties to be handled.