View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
headly headly is offline
external usenet poster
 
Posts: 45
Default 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