title: Rename Files with Index(Excel)
body: <p>Anyone have any ideas on how to rename files by finding an association with an index file?</p>
  
  <p>I have a file/folder structure like the following:
  Folder name = "Doe, John EO11-123"
  Several files under this folder</p>
  
  <p>The index file(MS Excel) has several columns.  It contains the names in 2 columns(First and Last).  It also has a column containing the number EO11-123.</p>
  
  <p>What I would like to do is write maybe a script to look at the folder names in a directory, compare/find an associated value in the index file(like that number EO11-123) and then rename all the files under the folder using a 4th column value in the index.</p>
  
  <p>So, </p>
  
  <p>Folder name = "Doe, John EO11-123", index column1 contains same value "EO11-123", use column2 value "111111_000000" and rename all the files under that directory folder to "111111_000000_0", "111111_000000_1", "111111_000000_2" and so on.</p>
  
  <p>This possible with powershell or vbscript?</p>