Any(Select()) - Return value from the bottom of the table first

[MatthewEngel]

Hi AppSheet Community 

I'm trying to solve an issue where i need the latest value of a table where the conditon is met. 

In Excel i'd use a Xlookup function and search it from the latest data entry(ie the latest row) up the rows returning the most recent entry that meets the criteria. 

How do we do this in appsheet? 
I currently have : 

any(Select(ShippingRates[Cost per Ton],[_THISROW].[Ship Routing]=[Ship Routing]))

This is used as an initial value in a column to get the latest shipping rate from the shipping rates table. 

The issue is the random select. I need it to be the largest row number where the criteria is met. 

Any pointers would be super helpful! 

PS. It would be amazing if appsheet were able to update the lookup function to allow the user to select how the function searches through the data. IE top to bottom or bottom to top 🙂