Is is possible to look up a value (Sales) in a table of ranges and return
another value depending on which range it falls into?

Code Sales Min Sales Max
A 10000
B 8000 10000
C 6000 8000
D 0 6000

So say I enter 9500 in a cell, I want it to return "B" as 9500 falls witin
that range of 8000-12000.

I've already created an IF statement that works but as I get more and more
ranges, it's going to get confusing and I think it maxes out at 7 conditions.
Just thought there might be an alternative to creat a table for the ranges
and do some sort of lookup or something.

Thanks!