SOLVED

Searching price in a range of weight

Occasional Contributor

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 Replies
best response confirmed by JGA74 (Occasional Contributor)
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.

Riny_van_Eekelen_0-1661762128702.png

 

@Riny_van_Eekelen
Thanks a lot! It works!