title: Excel: Looking up data and returning values from another spreadsheet
body: <p>In spreadsheet 2 I want to take the value in cell D [email address] and look up the email address on spreadsheet 1 in column D2:2000.  If there is a match by email address I want to return the corresponding cell value on spreadsheet 1 in column E to spreadsheet 2</p>
  
  <p>I feel like VLookup may accomplish this but I can't seem to find an exact response.</p>
  
  <p>MANY thanks for any help.</p>
  
  <p>Anne</p>