Slab Values

Hi All,


I need a formula to calculate values from slab Ranges.

for e.g

columnA columnB
1-10 A
11-20 B
21-30 C
31-40 D
41-50 E
51-60 F
61-70 G
71-80 H
81-90 I
91-100 J
101-110 K
111-120 L

If suppose value in cell c1 is 15, answer would be 'B' in cell D1 becuase it falls in 11-20 slab in A2.

I am using IF condition but it is not working for more than 7 times. Is there any other way to do this!

Thanks in advance!

lavi

are you stuck with your current layout? As in 10-20 all in one cell?

If your able to separate the data, column A being the lower size, column B being the upper and column being the Bin then a simple vlookup will do as you wish. If you drag the contents of column B into column C, then use the text to columns function, with - being your delimiter it will separate your data for you in the way i've suggested. Then it's just a Vlookup

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST