INDEX/MATCH Formula Improvement Help (with multiple worksheets/tabs)

[Morey]

=IFERROR(INDEX('Summary (WA1)'!B:B,MATCH(A2,'Summary(WA1)'!A:A,0)),IFERROR(INDEX('Summary (WA2)'!B:B,MATCH(A2,'Summary(WA2)'!A:A,0)),IFERROR(INDEX('Summary (WA3)'!B:B,MATCH(A2,'Summary(WA3)'!A:A,0)),IFERROR(INDEX('Summary (WA4)'!B:B,MATCH(A2,'Summary(WA4)'!A:A,0))&"",""))))
Is there ashorter (more efficient) formula? Also,how about a similar formula without ERROR handling?


Thanks in advance,

Morey

 

[Morey]

Never mind, figured out.