title: Microsoft Excel Referencing data
body: <p>I am trying to figure out how to look up a cell to see if it contains a name from a list I have specified, we will use "Hofmann Trucking" for example.</p>
  
  <p>Using columns a,b and c where column a contains average hours it takes for truck to travel from point a to point b, column b contains the carrier information (Hofmann Trucking) and finally column c which is where I would like the answer to go.</p>
  
  <p>I want column c to return the time listed in column a, only if Hofmann trucking is the carrier in column b. If another carrier is listed I would like to put that information in column d.</p>
  
  <p>In the end these times will be averaged per carrier per day so I can easily show how much time is spent traveling to and from certain areas by different companies.</p>