title: Horizontal Index Match (returning column header)
body: <pre><code>    A       B       C
  1 Fruit   Color   Meat &lt;- Column Header
  2 Banana  Red     Pork
  3 Apple   Black   Chicken
  4 Orange  White   Beef
  </code></pre>
  
  <p>From the table1 above to table2 below:  </p>
  
  <pre><code>    A       B     
  1 Name    What? &lt;- Column Header
  2 Banana  Fruit &lt;- Formula should return these values, based on table 1    
  3 Red     Color
  4 Beef    Meat
  5 Pork    Meat
  </code></pre>
  
  <p>Looking for a formula to return corresponding column name in B2,3,4...<br>
  I tried =INDEX(Table1[#Headers],MATCH(J:J,Table1,0)) </p>