Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP (with text)
Can you use VLOOKUP where you try to match text as the lookup value? When I
use the VLOOKUP function I get no return. No error message. Nothing. Not sure what it is and I'm wondering if text is the problem. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP (with text)
You can use text as the lookup value.
You probably want to get an exact match, so set the fourth argument within the VLOOKUP function to FALSE or 0. You might also need to use the TRIM( ) function so as to avoid any trailing spaces. You may actually be returning blank values - check your range and the column within that from which you want to return the values. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP (with text)
Oddly, when I added "FALSE" at the end of the formula for the range lookup,
it worked. Kind of strange that asking for an exact match works but approximate does not. "Woody13" wrote: Can you use VLOOKUP where you try to match text as the lookup value? When I use the VLOOKUP function I get no return. No error message. Nothing. Not sure what it is and I'm wondering if text is the problem. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP (with text)
Vlookup should work, are you sure you have satisfied all arguments of VLOOKUP
correctly? "Woody13" wrote: Can you use VLOOKUP where you try to match text as the lookup value? When I use the VLOOKUP function I get no return. No error message. Nothing. Not sure what it is and I'm wondering if text is the problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Looking up a string of text within a string of text | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
VLOOKUP first numerical value (not text) | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |