| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup only calling one cell
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT, calling a value from a cell as a value to search on | Excel Worksheet Functions | |||
| Calling cell values from random sheets from a base sheet | Excel Worksheet Functions | |||
| Calling procedure when leaving cell | Excel Worksheet Functions | |||
| Calling an Add-In | Excel Discussion (Misc queries) | |||
| When calling a different file, can I make the tab equal to a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
