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