vlookup in descending order

Hi guys. Fancy something to get your teeth into?

Im running a workbook that has a list of all the runs for a day, and several daily driver sheets that automatically copy and order the drops using vlookup.

However, runs 7 and 9 are trunked. We load the trunk wagons in reverse order so as to not confuse the loaders. The loads are then trans-shipped to the wagon that does the runs in the correct order.(the first cage off the trunk wagon becomes the first cage on the delivery wagon).

I am having a problem getting the drops in the correct order ( e.g. the last drop on the run list becomes the first drop on the daily drivers sheet.

run listing drop no 1 = daily sheet drop no 15

I hope this makes sense. Take a look at the attached spreadsheet.

Any ideas how to overcome this problem are greatly appreciated.

Thankyou

Colin