View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 20
Default Match and extract

I have 2 files. Column A of File1 has a short list of words but with no
meaning next to them. Whereas, File2 the reference file, contains a long
list of words together with their meanings in Column B. How can I match and
extract the information from File2 to Column B in File1? For instance, it
should not match "merge" with "emerge". Much appreciate your help.

Regards,
Tom