mariita
asked on
Excel index match formula not working
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.
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.
=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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I meant B2 (oops).
ASKER