title: Retrieve value of cell below, based on horizontal search of cell rows above
body: <p>I'm currently using Google Sheets. I have a spreadsheet that has a horizontal row of dates at the top. I'm attempting to search the horizontal date row for TODAY, and then return the value of a cell vertically below that header. So if TODAY's date is found in "H1" then return the value of "H24", if TODAY's date is found in "Y1" return the value of "Y24" etc and so on.</p>
  
  <p>I've tried <code>=vlookup</code> and <code>=hlookup</code>, but I can't get and semblance of results that aren't an error.</p>
  
  <p>Any help at all would be appreciated, as I'm definitely an Excel/Sheets novice.</p>