Lookup a number in a sliding scale table

Welcome to the Airtable community!

Your link is not working for me.

If you are trying to link to a specific record in a different table based on a combination of miles and stops, you might need to use a script instead of a formula. It is difficult to tell without more information.

Sorry, link updated. I have added some some rounded values so that there is an exact match to look for instead of looking for the closest match

You updated link gives editor permissions to whoever clicks the link.
I recommend that you change it to a read-only link so that you will not be billed for random people who click your link.

Or you could post screen captures instead. That would provide the most value to anyone who happens to read this post in the future.

Looking at the data, you cannot do this with a formula field (even with the rounded values). At least, not unless you can mathematically calculate the rate without having to use the table.

I recommend using a custom script to create the link for you.

Thanks,

Really appreciated.

Can anyone advise if they are able to help with a script?

If you are interested in hiring me to write a script, you can book a meeting with me.