How to select value from Column A when input value is between Columns B and C (Numbers)


As title would suggest. i’m trying to return a value from a datatable after inputting a value. this inputted value is a number that is between a Min and a Max value. one problem i have is that the datatable has 4 key indicators that all have there own seperate min/maxes and carriage prices.

Any ideas of how i can get the return i want from the Carriage column, depending on the input value?

I presume it’ll use a Lookup Datatable activity. but not quite sure how to build it.

Thanks for help.