title: Excel: find location of Max value across multiple worksheets
body: <p>I have a workbook containing 8 worksheets which are all of the same format. I have built a formula to calculate the Max value in a particular cell across all the worksheets:</p>
  
  <pre><code>=MAX(MAX('Equipment - A:Equipment - H'!C17))
  </code></pre>
  
  <p>This works great. It finds me the Max value out of the 8 instances of cell C17. </p>
  
  <p>What I now want to know is which sheet that Max value is found on. I tried to use the <code>MATCH</code> function, but it doesn't seem to work:</p>
  
  <pre><code>=MATCH(MAX('Equipment - A:Equipment - H'!C17),'Equipment - A:Equipment - H'!C17)
  </code></pre>
  
  <p>returns <code>#N/A</code>.</p>
  
  <p>All my Google searches tend to point to using <code>VLOOKUP</code> but this seems like a bit of a sledgehammer tactic.</p>
  
  <p>Any ideas?</p>