title: Excel: Use values in a sheet as index to list in a different sheet and replace values in the first sheet
body: <p>I have an XL file with some data to be manipulated. I think I will need to use a VB script to do this - but perhaps there is a simpler way with a formula. Just the same, could someone point out BOTH ways of achieving the following?</p>
  
  <p>I have a column of numeric values (ID) in Sheet 1.
  I want to use each ID as an index to lookup a list in Sheet 2.
  Sheet 2 has two columns
  First column is the index and Second column is the Text String
  e.g. </p>
  
  <p>1 Apple</p>
  
  <p>2 Orange</p>
  
  <p>3 Pear</p>
  
  <p>What I want is to replace the column of IDs in sheet 1 with the looked up text string from Sheet 2!</p>
  
  <p>Thats all...
  Please help!</p>