folks,
Im using the following to return a value which it does =INDEX('[18-19 Jim Paterson.xlsx]Case data'!$A$2:$D$800,MATCH(N17,'[18-19 Jim Paterson.xlsx]Case data'!$E$2:$E$800,0),1)
I want to add to this formula so that it will lookup several other workbooks. I've done something similar with vlookup and nesting iferrors.
I tried the below but didn't work
=IFERROR(INDEX('[18-19 Ralph Graham.xlsx]Case data'!$A$2:$D$800,MATCH(N17,'[18-19 Ralph Graham.xlsx]Case data'!$E$2:$E$800,0),1),IFERROR(INDEX('[18-19 Jim Paterson.xlsx]Case data'!$A$2:$D$800,MATCH(N17,'[18-19 Jim Paterson.xlsx]Case data'!$E$2:$E$800,0),1)))
Any help would be appreciated
Cheers