I am attaching the file in question. If you look at the bottom left of the bordered box, you see the sections in red font (cell B20-B21), in cell C20 I have a drop down list which references a list of temepratures from cells B31-B190. I want the cell C21 to return the value from C31-C190 that corresponds with the value (from B31-B190) that you select in C20.

So for example, if in cell C20, you select 20.6, cell C21 will return a value of 0.998078.

I tried using HLOOKUP but with little succes, can anyone help me?template.xlsx

Its the file I've named "template"

Please help!