Beatrice
Board Regular
- Joined
- Sep 17, 2019
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
greeting, I need some help to look for the related prices, example list as below:
I need a formula not only look for the exact value, but also include the odd sizes not from the list. (equal or greater than)
for example, 60 x 85 should take PRICE at 1000.
another example 45 x 75 will have to take PRICE 1200 (rotated to fit)
Thank you in advance for helping.
Length (cm) | Width (cm) | PRICE |
25 | 35 | 200 |
35 | 50 | 300 |
33 | 70 | 350 |
41 | 57 | 400 |
46 | 64 | 500 |
50 | 70 | 600 |
57 | 82 | 800 |
64 | 90 | 1000 |
70 | 100 | 1200 |
I need a formula not only look for the exact value, but also include the odd sizes not from the list. (equal or greater than)
for example, 60 x 85 should take PRICE at 1000.
another example 45 x 75 will have to take PRICE 1200 (rotated to fit)
Thank you in advance for helping.