Vlookup using partial word, first 4 letters
 

Searching for a value in a table array, spelling may not match exactly (i.e.
hyphen, no hyphen, apostrophe, no apostrophe) so I wanted to try matching the
first 4-5 letters of the word. Tried to use left with search but no luck. Any
ideas appreciated. TIA

Vlookup using partial word, first 4 letters
 

It works fine, you need to array enter it with ctrl + shift & enter

=VLOOKUP("abcd",LEFT(A3:B50,3),2,0)


as an example of the first 4 letters,

--


Regards,


Peo Sjoblom


"headly" wrote in message
...
Searching for a value in a table array, spelling may not match exactly
(i.e.
hyphen, no hyphen, apostrophe, no apostrophe) so I wanted to try matching
the
first 4-5 letters of the word. Tried to use left with search but no luck.
Any
ideas appreciated. TIA

Vlookup using partial word, first 4 letters
 

But that returns a value from column B that may be truncated.

(I'm not saying anything about the 3 in the =left() portion <vvbg.)

How about:

=INDEX(B3:B50,MATCH("abcd",LEFT(A3:A50,4),0))
(still an array formula)

Peo Sjoblom wrote:

It works fine, you need to array enter it with ctrl + shift & enter

=VLOOKUP("abcd",LEFT(A3:B50,3),2,0)

as an example of the first 4 letters,

--

Regards,

Peo Sjoblom

"headly" wrote in message
...
Searching for a value in a table array, spelling may not match exactly
(i.e.
hyphen, no hyphen, apostrophe, no apostrophe) so I wanted to try matching
the
first 4-5 letters of the word. Tried to use left with search but no luck.
Any
ideas appreciated. TIA

--

Dave Peterson