A
Alexander
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.
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.