title: ADDRESS() inside an OFFSET() function on excel
body: <p>I have the following function which returns the maximum column value location:</p>
  
  <pre><code>=ADDRESS(MATCH(MAX(B1:B18),B1:B18,0),1)
  </code></pre>
  
  <p>when I add OFFSET to the function to get the corresponding value in another column it does not work!</p>
  
  <pre><code>=OFFSET(ADDRESS(MATCH(MAX(B1:B18),B1:B18,0),1),1,0)
  </code></pre>
  
  <p>Any other way to do this? </p>
  
  <p>I have two colomns:</p>
  
  <pre><code>Time (hours)    Cp (ug/L)
  0               0
  0.1             26.282
  0.25            46.532
  0.5             57.046
  0.75            57.411
  1               55.028
  </code></pre>
  
  <p>I want to find the maximum value in Cp colomn and return the time at that maximum value. In this example, maximum value is 57.411 and it was at time 0.75.. the field should return 0.75</p>