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.
The spreadsheet with input data looks like this:
The spreadsheet with the output/formulas looks like this:
This is the formula that I am using, but it is returning a #VALUE! error.