title: SharePoint List - vLookup type functionality
body: <p>I currently maintain a excel spreadsheet that contains a list of upcoming classes. In addition to the standard columns, I also have some columns containing vLookups. These are used to populate additional information. For example, when someone sets the class country as "Australia", the vLookup sets the region to "Asia Pacific".</p>
  
  <p>Worksheet 1:</p>
  
  <ul>
  <li>A: Class Name (Text)</li>
  <li>B: Class Location Country (Text)</li>
  <li>C: Class Region (vLookup to worksheet 2)</li>
  </ul>
  
  <p>Worksheet 2:</p>
  
  <ul>
  <li>A: Country</li>
  <li>B: Region</li>
  </ul>
  
  <p>I would like to move this excel file to a SharePoint list but cant figure out how to implement the same "vLookup" type function. If the class location is set to "Australia" it needs to lookup the region from another list.</p>
  
  <p>Really appreciate any tips.</p>
  
  <p>Thanks,</p>
  
  <p>Ash</p>
  
  <p>Ps. I am using SharePoint 2010.</p>