title: MATCH function won't work with a cell reference
body: <p>I am trying to use <code>INDEX</code>/<code>MATCH</code> functions in a spreadsheet with multiple sheets.</p>
  
  <p>Basically, I want Excel to look at the value in cell C3, find the row on another sheet that matches the value of C3, and return the value of the cell in column H in that row.</p>
  
  <p>This formula I wrote below works if I put the value of C3 in quotes (e.g. <code>"99213"</code>), but it returns <code>#N/A</code> if I use the cell reference itself (e.g. <code>C3</code>; see below).</p>
  
  <p>Am I missing something here? If it helps, the values in column C consist of 5-digit alpha-numeric strings, formatted as "General".</p>
  
  <pre><code>=INDEX('2015 RVU data'!$H$8:$H$8922,MATCH(C3,'2015 RVU data'!$A$8:$A$8922,0))
  </code></pre>