How to Get a value from a table range

[jamiguel77]

How to Get a value from a table range

Examen_Parcial3_20211_215A (1).xlsx
	A	B	C	D	E	F
3
4	de 1 a 10	30%		17	15%
5	de 11 a 15	20%
6	de 16 a 25	15%
7	de 26 a mas	10%
8
9
Hoja2

in the sample" i typed in D4 a value 17 and in E4 the result is (checking the range) 15% how to determine this 15% with a formula?

2_ need recreate the table in 2 columns for the range?

thanks

 

[Toadstool]

Hi Jamiguel77,

You can use MATCH to look for the smallest value less than or equal to your number. Yes, you'll need to have a new table with just the borrom of each range. Also note if they may enter below 1 you should have a first entry with something like -99999 so it always find that.

Jamiguel77.xlsx
	A	B	C	D	E	F
4	de 1 a 10	1	30.00%		17	15.00%
5	de 11 a 15	11	20.00%
6	de 16 a 25	16	15.00%
7	de 26 a mas	26	10.00%
Sheet1

Cell Formulas
Range	Formula
F4	F4	=INDEX($C$4:$C$7,MATCH(E4,B4:B7,1))

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E
3
4	1	30%		17	0.15
5	11	20%
6	16	15%
7	25	10%
8
Customers

Cell Formulas
Range	Formula
E4	E4	=VLOOKUP(D4,A4:B7,2,1)

 

[jamiguel77]

Hey both worked.....

thanks

 

[Fluff]

Glad we could help & thanks for the feedback.