Is there a single function that will look at a table array and see which
values the target number is between and return the appropriate result? There
are many, many values in the table array so if doesnt work.

For example, see the table below. If a particular cell's value is 260, that
would be between 250 and 300 and would return the value to the right in that
column, which is 200

400 450 300
350 400 250
300 350 200
250 300 150
200 250 100
150 200 50
100 150 0
50 100 0
0 50 0