HLOOKUP Help. HLOOKUP links to Drop down list problems

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!

Formula:

Please Login or Register  to view this content.

you actualy want to do a VLOOKUP. this finds the number down C31 - C190, then shows the value of the cell next to it.

copy the formula into C21 and see if it works

Originally Posted by rossg

Formula:

Please Login or Register  to view this content.

you actualy want to do a VLOOKUP. this finds the number down C31 - C190, then shows the value of the cell next to it.

copy the formula into C21 and see if it works

Thanks a lot! This works great!