You need to sort your first table.

Hope this helps.

Pete


On Sep 21, 8:25*pm, Alexander
wrote:
Hello,
I am trying to use vlookup to search for a temperature within the following
data and return the corresponding "hot" or "cold."

t1 * * *t2 * * *stream
20 * * *135 * * cold
170 * * 60 * * *hot
150 * * 80 * * *cold
50 * * *140 * * hot

THE RESULT:

T * * * Ti
170 * * hot
150 * * cold
140 * * cold
135 * * cold
80 * * *cold
60 * * *cold
50 * * *cold
20 * * *cold

After the first temperature (170), the formula is only returning the
top"cold" *(C3) within the above table. *Here is my formula: *
=VLOOKUP(A8,$A$2:$C$5,3)

Is there something about the vlookup function I am missing? *Any help is
much appreciated, thank you.