Hi guys,

This formula returns the correct value using index and match but I need to include other workbooks(all the same format) in the index and match as well.

{=INDEX('[18-19 Jim Gormley.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'[18-19 Jim Gormley.xlsx]Case data'!$E$2:$E$800,0),1)}

I've tried iferror but couldn't get it to work

Any help would be appreciated.

Cheers