title: Excel index match formula to pull data from another tab/file
body: <p>I am trying to use Excel's index match functions to pull data from one spreadsheet into another. For now, I am trying to get it to work with the data in a separate tab, but eventually I would like to pull the data in from a separate file.</p>
  
  <p>The spreadsheet with input data looks like this:
  <img src="https://i.stack.imgur.com/pyQNg.png" alt="The spreadsheet with input data looks like this:"></p>
  
  <p>The spreadsheet with the output/formulas looks like this:
  <img src="https://i.stack.imgur.com/R7flx.png" alt="The spreadsheet with the output/formulas looks like this:"></p>
  
  <p>This is the formula that's in cell B2 of the output spreadsheet, but it's returning a #VALUE! error:</p>
  
  <pre>
  =INDEX(extract!$D$2:$D$2000,MATCH($B1&$A2,extract!$A$2:$A$2000&extract!$B$2:$B$2000&extract!$C$2:$C$2000,0),1)
  </pre>