Forum Discussion
Solved
excell
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 o...
That could be like
LOOKUP(value, {0, 250, 280, 350, 400},{1,2,3,4,5})if use another table data instead
Thank you very much
You are welcome. But better not to hardcode constants inside the formula but use table with them. Above is only idea.
- Yes I did that. I did not hardcore it but used the values from a table.
Great!