| 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 |
| 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 | |||
Threaded Mode
