index and match with iferror wrapper

[pikepro92]

=INDEX('\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$E$2:$E$800,0),1)

Hi guys the formula above returns the value I'm looking for but I want to add more workbooks to index and match from.

I've tried this for example but it says I've entered too few arguments ? Entered with ctrl shift enter obv.

=IFERROR(INDEX('\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$E$2:$E$800,0),1),IFERROR(INDEX('\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 GC.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 GC.xlsx]Case data'!$E$2:$E$800,0),1)))

Any help ?

Cheers​

 

[AlanY]

=INDEX('\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$E$2:$E$800,0),1)

Hi guys the formula above returns the value I'm looking for but I want to add more workbooks to index and match from.

I've tried this for example but it says I've entered too few arguments ? Entered with ctrl shift enter obv.

=IFERROR(INDEX('\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 JG.xlsx]Case data'!$E$2:$E$800,0),1),IFERROR(INDEX('\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 GC.xlsx]Case data'!$A$2:$D$800,MATCH($N$17,'\\c\s\CAF1\FIS PoC Communications Hub\1. Performance\ML\[18-19 GC.xlsx]Case data'!$E$2:$E$800,0),1),"?"))

Any help ?

Cheers​

you need to add a condition when no match for both

 

[pikepro92]

you need to add a condition when no match for both

Brilliant. Thanks. Would there be any reason why it will not work beyond the 3rd if error? Trying to add a fourth workbook but it says there's a problem found in the formula

 

[AlanY]

you're welcome.

as for your question re the 3rd iferror, it should works