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
Two questions.
1. What value do you want for an exact match? So, when A=250 or A=280
2. If the target is not an exact match, you want the value from the next *higher* number. So, for 281 you want 40. Correct?
1. What value do you want for an exact match? So, when A=250 or A=280
2. If the target is not an exact match, you want the value from the next *higher* number. So, for 281 you want 40. Correct?
- If you have Office 365, you can use Xlookup, and use the option for "Exact match and next higher value".
