May 28 2021 11:02 PM
I need to pull out a value from a table. If A=250, in another table the values are say..250, 280, 350, 400. and the second column has another value . Like for 250 is 30, 280 is 35, 350 is 40.... so on. If I have A=260 then how do I pull out the value. Which means I need 35 which is A>250 and A< 280. so the corresponding value of 280 is 35.
May 28 2021 11:47 PM
May 29 2021 12:45 AM
May 29 2021 04:31 AM
May 29 2021 06:26 AM
SolutionThat could be like
LOOKUP(value, {0, 250, 280, 350, 400},{1,2,3,4,5})
if use another table data instead
May 31 2021 02:34 AM
You are welcome. But better not to hardcode constants inside the formula but use table with them. Above is only idea.
May 31 2021 02:38 AM
May 29 2021 06:26 AM
SolutionThat could be like
LOOKUP(value, {0, 250, 280, 350, 400},{1,2,3,4,5})
if use another table data instead