find data from certain category

[Afarag]

Dears,
appreciate you help,
i have some values that fall into different categories, and I want to know the value falls within a category and achieve it's Percentage
Ex:

i have a value "21" that located in a category between "20 to 24" and achieve "5%"
if i have a value 11 i want a function that let me know it's categorie's Percentage



from to Percentage
1 4 1%
5 9 2%
10 14 3%
15 19 4%
20 24 5%
25 29 6%
30 34
7%

 

[Sam Mathai Chacko]

You can actually ignore the 'To' column. Assuming your 'From' and 'Percentage' data are in columns C and A, starting from first row, use this

=INDEX($C$1:$C$7,MATCH(YourLookUpValue,$A$1:$A$7,1))

 

[bobhc]

Good day Afarag

Does the upload do as you want?

 

[Luke M]

You don't need the "To" column, as a single column lets you know the thresholds. Then your formula is just:
=LOOKUP(MyValue,A2:A10,C2:C10)
If you remove the middle column, formula gets even shorter to:
=LOOKUP(MyValue,A2:B10)

 

[Afarag]

Dears,
I was expecting resolved harder than that, but like a piece of cake
hooray and thank you so much

 

[bobhc]

Afarsaq

Recheck my upload

 

[Afarag]

bobhc :D

no problem never with your attach file, it's very useful and right, it was a very easy solution but i didn't concentrate
thank you very much man, appreciate you great effort and your totally new look

 

[bobhc]

it is just a small improvement so that if there is no data in Quantity there is a reminder displayed.

 

[SirJB7]

Hi, Afarag!
If the percentage distribution is so linear you could shorten the formula to this:
=ENTERO((F1+5)/5)/100 -----> in english: =INT((F1+5)/5)/100
Regards!