Forum Discussion
Solved
Searching price in a range of weight
Hi all,
What formula should I use to get the value of a cell in another table to give me the corresponding price range it is in?
For example, I need to find the price of 4.46Kg in the price list.
Weight (from) | Weight (to) | Price |
0 | 1 | 15.00 |
1.01 | 2 | 15.50 |
2.01 | 3 | 16.00 |
3.01 | 4 | 16.80 |
4.01 | 5 | 16.90 |
5.01 | 6 | 17.00 |
Thanks in advance for your help.
JGA74 You don't really need to (To) column. Use LOOKUP on the (From) column to return the corresponding value from the Price column. Example attached.
JGA74 You don't really need to (To) column. Use LOOKUP on the (From) column to return the corresponding value from the Price column. Example attached.
- Riny_van_Eekelen
Thanks a lot! It works!
