Vlookup using partial word, first 4 letters

H

headly

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
 
P

Peo Sjoblom

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
 
D

Dave Peterson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and Vlookup issue 2
VLookup is not returning the first match data 6
Partial String Match Using VLOOKUP 4
Functions, Arrays and number/text stored as text 3
Excel, partial search for Vlookup 2
When Using VLOOKUP With MATCH How Do I Handle #NA OnData Retrieval 2
When Using VLOOKUP With MATCH How Do I Handle #NA OnData Retrieval 1
When Using VLOOKUP With MATCH How Do I Handle #NA OnData Retrieval? 2

Top