Forum Discussion
Look up a value to assign a label
Is there a function I can use to look up a value and assign a label if it's less then another value; for example, I have a list of numbers, with an assigned label and a number I want to search. V...
Thanks for your response. How would I set up the xlookup function if this were the table:
MP Levels MP Level
5 0005
20 0020
50 0050
100 0100
200 0200
300 0300
500 0500
750 0750
1,000 1000
1,500 1500
2,500 2500
3,500 3500
5,000 5000
7,500 7500
And I wanted to lookup a value of 3445 which resides is cell a45?
I tried xlookup but got an error response so I must not be using the function properly.
MP Levels MP Level
5 0005
20 0020
50 0050
100 0100
200 0200
300 0300
500 0500
750 0750
1,000 1000
1,500 1500
2,500 2500
3,500 3500
5,000 5000
7,500 7500
And I wanted to lookup a value of 3445 which resides is cell a45?
I tried xlookup but got an error response so I must not be using the function properly.
- I figured out xlookup. That was the solution I was looking for. Thanks!!