title: Returning the column header of max value on per row basis
body: <p>I have a spreadsheet whereby on a monthly basis I need to return the top product based on a table for that month. I have copied a screenshot of my current setup below. </p>
  
  <p><img src="https://i.stack.imgur.com/PpFba.jpg" alt="enter image description here"></p>
  
  <p>I am currently doing this by creating an additional column (column <code>H</code>) which uses the <code>INDEX</code>, <code>MATCH</code> and <code>MAX</code> functions to return the name of the highest product in that row. </p>
  
  <p>I then use another <code>INDEX</code> <code>MATCH</code> as a lookup in cells <code>K4</code> and <code>L4</code> to return the value for that month. </p>
  
  <p>The problem is that my table expands each month as a new row is added and I wanted to find out if there was a way to combine both the formulas into one. So that all I would need to do is update the current and previous months in cells <code>K3</code> and <code>L3</code>. I have the same setup across quite a few sheets so want to automate as much as possible.</p>
  
  <p>Would love some help, ideally without using VBA if possible at all. </p>