VLOOKUP (with text)

[Woody13]

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.

[Pete]

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

[Woody13]

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.

[ufo_pilot]

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.