excel macro

Job ID: 37040623

Budget: ₹600 – ₹1,500 INR

I want a program or formulae which gives the value corresponding to header row Item for example "Sand" and Lead in KM say "4.7" from coulmns
Answer : ans should be the value interpolation between value correspondin to 4.5km and 5km in the table
details explained in exceld