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
Bookmarks