Finding range on table based on value

[dannwid]

I have no idea how to ask this question.
Basically, I have a table1 that contains some range of price/value that carries certain rates.
In other hand, I have a table2 that contains value/price. I need to match price in table2 to rate in table1.

This is my situation, red is my "go to" based on table on the left (by matching those blue font). What kind of formula I can use to get result on red font.

Thank you in advance. Hope my question is understood.

Find range.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2
3		RANGE OF RATES:					RESULT:
4		No.	From	To	RATE		Item	Price	Rate
5		1	-	100	0,00%		Item-1	90	0,00%
6		2	101	200	1,00%		Item-2	250	3,00%
7		3	201	400	3,00%		Item-3	1.300	8,00%
8		4	401	1.000	5,00%		Item-4	1.800	8,00%
9		5	1.001	>1.001	8,00%		Item-5	800	5,00%
10							Item-6	800	5,00%
11							Item-7	1.800	8,00%
12							Item-8	200	1,00%
13							Item-9	300	3,00%
14							Item-10	95	0,00%
15
16
Sheet1

 

[Fluff]

How about

=XLOOKUP(H5,$C$5:$C$9,$E$5:$E$9,"",-1)

 

[dannwid]

How about

=XLOOKUP(H5,$C$5:$C$9,$E$5:$E$9,"",-1)

Wow, it works.
Well, thank you. I don't realized that "-1" is the key. So this "-1" will resulting next smaller percentage (column E) if value on H can't be found on C, right?

Thank you.

 

[Fluff]

That's right.