title: Replace Strings with IDs in Excel
body: <p>I have a Microsoft Excel worksheet that has hundreds of rows of items.  The category column in this items worksheet is filled with category names, which are duplicated since it's a many-to-one relationship of items to categories.  I would like to replace these category strings with IDs from a second worksheet that has a unique list of the category names paired with IDs.  So, the common link between the two is the category name.</p>
  
  <p>How can I do this in Microsoft Excel?  Does it involve making a vba macro?</p>