Auto fill a cell with a value based on pre-defined range.

Hello everyone.

A have three columns with "Kilograms range" and corresponding value.
A========== B========== C
KG From====-To======= Predefined Value

Will you be so kind to tell me what formula will fill up the cell with the predefined value automatically based on the range, after a kilograms are entered in a different cell as explained in the attachment.
Thank you!
K

With VLookup.

See the attached file.

See the answer in E15, if gives an differant answer as your D15.