Index Match formula accross 5 different workbooks

[jpulse]

I have a workbook that has item numbers for about 100 different products. I created a formula that will pull in data, located on 5 other workbooks, such as item description and serial number. My formula is formatted for each individual criteria.. My question is how can I make the formula search across all workbooks, instead of just one particular workbook? Is there a way to write one formula to drag across all cells, instead of customizing it for each criteria?

Formula to get Item Description:

=IFERROR(INDEX(All78C.csv!$D:$D,MATCH(A2,All78C.csv!$E:$E,0)),"""")

A2 = Item number
$D:$D = Item description located on All78C.csv
$E:$E = Item number located on All78C.csv

Formula to get Serial Number:

=IFERROR(INDEX(All78C.csv!$F:$F,MATCH(A2,All78C.csv!$E:$E,0)),"""")

A2 = Item number
$F:$F = Item description located on All78C.csv
$E:$E = Item number located on All78C.csv


Workbooks needed to search through:

ALL78C.CSV
ALL78D.CSV
ALL78M.CSV
ALL78P.CSV
ALL780.CSV

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Item Number[/TD]
[TD="align: center"]Item Description[/TD]
[TD="align: center"]Serial Number[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]10001[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]10002[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]10003[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]10004[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Iferror(index(file1... ,iferror(index(file2... ,iferror(index(file3... ,iferror(index(file4... ,iferror(index(file5... ,"")))))

 

[jpulse]

This is what I came up with:

=IFERROR(INDEX([All780.csv]All780!$D:$D,MATCH(A591,[All780.csv]All780!$E:$E,0,(IFERROR(INDEX([All78C.csv]All78C!$D:$D,MATCH(A591,[All78C.csv]All78C!$E:$E,0,(IFERROR(INDEX([All78CSP.csv]All78CSP!$D:$D,MATCH(A591,[All78CSP.csv]All78CSP!$E:$E,0,(IFERROR(INDEX([All78D.csv]All78D!$D:$D,MATCH(A591,[All78D.csv]All78D!$E:$E,0,(IFERROR(INDEX([All78M.csv]All78M!$D:$D,MATCH(A591,[All78M.csv]All78M!$E:$E,0,(IFERROR(INDEX([All78L.csv]All78L!$D:$D,MATCH(A591,[All78L.csv]All78L!$E:$E,0,(IFERROR(INDEX([All78P.csv]All78P!$D:$D,MATCH(A591,[All78P.csv]All78P!$E:$E,0,""))))))))))))))))))))))))))

But, it says "You've entered too many arguments for this function"

 

[jpulse]

=IFERROR(INDEX([All780.csv]All780!$D:$D,MATCH(A591,[All780.csv]All780!$E:$E,0,IFERROR(INDEX([All78C.csv]All78C!$D:$D,MATCH(A591,[All78C.csv]All78C!$E:$E,0,IFERROR(INDEX([All78CSP.csv]All78CSP!$D:$D,MATCH(A591,[All78CSP.csv]All78CSP!$E:$E,0,IFERROR(INDEX([All78D.csv]All78D!$D:$D,MATCH(A591,[All78D.csv]All78D!$E:$E,0,IFERROR(INDEX([All78M.csv]All78M!$D:$D,MATCH(A591,[All78M.csv]All78M!$E:$E,0,IFERROR(INDEX([All78L.csv]All78L!$D:$D,MATCH(A591,[All78L.csv]All78L!$E:$E,0,IFERROR(INDEX([All78P.csv]All78P!$D:$D,MATCH(A591,[All78P.csv]All78P!$E:$E,0,"")))))))))))))))))))))

Took out the parentheses before IFERROR statement
Still get same error

 

[Special-K99]

Your MATCH statements don't look correct, it should be MATCH(find value, in range, matchtype)
Your match type is 0 but you havent closed the brackets, and you shouldnt need that many brackets at the end of the formula. You only need as many brackets as you have IFs/IFERRORs.
Does this work?

=IFERROR(INDEX([All780.csv]All780!$D:$D,MATCH(A591,[All780.csv]All780!$E:$E,0),IFERROR(INDEX([All78C.csv]All78C!$D:$D,MATCH(A591,[All78C.csv]All78C!$E:$E,0),IFERROR(INDEX([All78CSP.csv]All78CSP!$D:$D,MATCH(A591,All78CSP.csv]All78CSP!$E:$E,0),
IFERROR(INDEX([All78D.csv]All78D!$D:$D,MATCH(A591,[All78D.csv]All78D!$E:$E,0),IFERROR(INDEX([All78M.csv]All78M!$D:$D,MATCH(A591,[All78M.csv]All78M!$E:$E,0),IFERROR(INDEX([All78L.csv]All78L!$D:$D,MATCH(A591,[All78L.csv]All78L!$E:$E,0),IFERROR(INDEX([All78P.csv]All78P!$D:$D,MATCH(A591,[All78P.csv]All78P!$E:$E,0,"")))))))

The length of this formula is making me think that some form of lookup table may be better.