title: Sharepoint: Calculated column based on another list
body: <p>I could be looking at the wrong way to do this, but here I go:</p>
  
  <p>I have a Sharepoint list (titled "Trips"), which has a list of trips scheduled to particular zones. I have a second list ("Zones"), which has a fixed number of items, each item representing a particular zone. Zones has a column titled "Condition" describing the roads in that particular area.</p>
  
  <p>Now... given that an item in Trips contains a reference to the Zone item where the trip is heading, I want to be able to "look up" the Condition column for that Zone item and include it in Trip views. Problem being, if I add a lookup column to Trips, it only allows me to select the title column from Zones, which is just the zone name.</p>
  
  <p>Any thoughts?</p>