title: excel macro to read text file and find matches in cells
body: <p>I really could use some help </p>
  
  <p>I have two .txt/csv files that I need to read from into my excel file.</p>
  
  <p>In my excel file I have a whole column, each cell containing string of characters and I need to write a script to be able find matches and and copy an adjacent column from that txt file.</p>
  
  <p>An example of a single row on my txt file is shown below:</p>
  
  <p>"AB101AA","AB10 1AA","AB101A","AB10 1A","AB101","AB10 1","AB10","AB10","AB","10",394251,806376,,
  "AB101AF","AB10 1AF","ABERDEEN","ABERDEENSHIRE",,"ABERDEEN, CITY OF" </p>
  
  <p>My excel file would have a cell which probably say "AB101AF" and i want the corresponding cell to run through a million rows and find the match and then find the corresponding nth cell on the txt file and return it on the excel spreadsheet example "ABERDEEN, CITY OF".</p>
  
  <p>I know I havent been helpful in explaining the issue. But any help would be appreciated.</p>
  
  <p>Thank you</p>