title: Excel - Find a value in an array and return the contents of the corresponding column
body: <p>I am trying to find a value within an array and then return the value in a specific row in the corresponding column.</p>
  
  <p>In the example below, I need to know which bay the Chevrolet is in:
  <br/></p>
  
  <pre><code>    Column A        Column C    Column D    Column E
      Chevrolet       Bay 1       Bay 2       Bay 3
                      Toyota      Ford        Saturn
                      Honda       Chevrolet   Jaguar
                      Ferrari     Subaru      Lexus
                      Mitsubishi  Hundai      BMW
  </code></pre>
  
  <p>I am looking for Chevrolet in the array C2:E5.  Once it determines that the Chevrolet is in Column D, I need for it to return the value in D1.  If it was in column E, I need it to return the value in E1.</p>
  
  <p>Any help would be greatly appreciated.  Thank you so much in advance.</p>