title: How do you find the max in a particular cell across all sheets and return a different cell?
body: <p>I have been able to return the max value of F1 from all sheets by using this formula located in cell G13:</p>
  <pre><code>G13=MAX(ABC:XYZ!F1)
  </code></pre>
  <p>Now I also want to return the value of A5 from the sheet where the MAX was found in G13.</p>
  <p>How do I write the formula for that?</p>
  <p>TIA.</p>