| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I reduce the spaces between letters in a word? | Excel Discussion (Misc queries) | |||
| Vlookup partial text from a single cell | Excel Worksheet Functions | |||
| Partial String Match & Wild Cards Using VLOOKUP | Excel Worksheet Functions | |||
| Partial String Match Using VLOOKUP | Excel Worksheet Functions | |||
| How do you sort words in Excel by the number of letters in a word | New Users to Excel | |||
Hybrid Mode
