This should be simple, but I can't find a solution.
I tried VLOOKUP, but it returns a lower value, and I need it to ROUNDUP.
The lookup value is 17%
The Lookup Table is:
The return value that should be returned is 8, because 17% is greater than 10%
If the lookup value is 25%, the return value should be 7.
Any advice or insight would be greatly appreciated.