title: How to create an Index Match formula that pulls the answer from the most current column
body: <p><img src="https://i.stack.imgur.com/y0lTE.png" alt="Excel Sheet"></p>
  
  <p>Hi I am trying to figure out how to create an index match, so that the information pulls from the most current date. 
  Prices change weekly when buying wine and liquor.
  So I understand Index Match, but I am trying to add MAX to it, to pull up the most current date and it isn't working.</p>
  
  <p>What formula would I use?
  Currently I have came up with something like this:</p>
  
  <pre><code>=INDEX(E3:P53,MATCH("Aplanta",B3:B55,0),MAX(E2:P2))
  </code></pre>