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.
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 | ||||||||||||
