look-up in a range
In your table (which I'll assume is A2:B5), change the left column to these
values:
1
11
16
31
Now your lookup formula is simply:
=LOOKUP(A2,A2:B5)
You don't state what you want to happen though if its outside those ranges.
You could change your table to this to accomodate:
0 "Too small"
1 $5
11 $8
16 $12
31 $15
51 "Too big"
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Jimmy" wrote:
A1 is a user-entered value for # of employees.
I have a 35 row tiered rate sheet based on number of employees. What
is the best way to look-up A1 and match it to the correct range-row.
Ex:
A1=33
1-10 $5
11-15 $8
16-30 $12
31-50 $15
Thanks!
|