Searching price in a range of weight

[JGA74]

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.

[#2 · Accepted solution]

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

[#3]

@Riny_van_Eekelen
Thanks a lot! It works!