title: Looking up Excel data when the key column (one with reference values) is not leftmost
body: <p>I have one Excel spreadsheet which has the following columns:
  Surname / First Name / e-mail / gender / info 1 / info 2 / info 3 / info 4 
  This is a master spreasheet with everyone's details.</p>
  
  <p>I have another spreadsheet containing just the e-mail addresses of a handful of people. All of them are in the master spreadsheet.
  The columns are as follows: Surname / First Name / e-mail / Project / gender / info 2 / info 3 / info 4 / info 1</p>
  
  <p>Is there a way of asking Excel to look in the e-mail column of the master spreadsheet and search for the e-mail mentioned in the other spreadsheet. When the matching e-mail is found, look up data in master spreadsheet for that person, and transpose them into appropriate columns in the other spreadsheet. </p>
  
  <p>I'm happy to clarify anything that doesn't make much sense. </p>
  
  <p>Cheers!</p>
  
  <p>EDIT: changed title from "Importing data from another Excel spreadsheet based on specific values" to "Looking up Excel data when the key column (one with reference values) is not leftmost"</p>