INDEX MATCH across more than one sheet?

[FatalLordes]

Hi all. So I know how to do INDEX MATCH on one sheet, namely:

=INDEX(Main!I:I, MATCH(Report!B3, Main!A:A,0))

But what if I want to do the same thing but across multiple sheets? I tried the obvious, namely:

=INDEX(Main!I:I,Second!I:I, MATCH(Report!B3, Main!A:A,Second!A:A,0))

But that ends up in a "You've entered too many arguments" error. How would I go about this?

Thanks in advance

 

[Alex Blakenburg]

What is the exact formula you are using ? and what is the error message ?