Vlookup - Partial

[jRyan2003]

OS=W2K
XL=2K

Is it possible to have Vlookup work on only part of a cell entry? For example:

A1 = QWERTY 05

I would like to be able to do a lookup on QWERTY and return a value based on that.

Thanks,

 

[texasalynn]

when you create the formula leave off the last parameter.

=vlookup(a1,table data,2)
for an exact match you add
=vlookup(a1,table data,2,false)

HTH
texasalynn

 

[just_jon]

Is it that you want to search for everything before the space; the first x characters, etc?

What are the rules for the partial string?

=VLOOKUP(LEFT(A1,FIND(" ",A1)-1),Table,ColID,TF)

may work depending on your exact requirements...

 

[jRyan2003]

when you create the formula leave off the last parameter.

=vlookup(a1,table data,2)
for an exact match you add
=vlookup(a1,table data,2,false)

HTH
texasalynn

Thanks. That worked.

 

[Paul Edmondson]

I found that the easiest way to do this is to build the LEFT function into the LOOKUP.

In the example you've given, the first part of your function would look like this:

=VLOOKUP(LEFT(A1,6))

The '6' is the number of characters that you want to search for.

Hope this helps!

Regards

 

[jRyan2003]

I found that the easiest way to do this is to build the LEFT function into the LOOKUP.

In the example you've given, the first part of your function would look like this:

=VLOOKUP(LEFT(A1,6))

The '6' is the number of characters that you want to search for.

Hope this helps!

Regards

Better yet!!! Thanks...

 

[Aladin Akyurek]

If A1 houses the partial lookup value like QWERTY, then:

=VLOOKUP(A1&"*",Table,ColIdx,0)

would suffice if the requirement is: any value befinning with A1.