Lookup Table
Yes, as long as the data is sorted (as yours is, but it would be
easier if it was in the opposite order to what you show), then you
could use VLOOKUP.
Tell us more about what you want to do.
Pete
On Dec 11, 4:22*pm, empire11
wrote:
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!
|