Index and Match across multiple work sheets.

[Vioman]

:dunno Ok i have tried to look up several solutions but nothing seems to fit or answers my problem. I am trying to index and match across several worksheets. Here is my formula

=INDEX(Current1!$A$2:$D$60000,(MATCH(1,(Current1!$A$2:$A$60000=$O11)*(Curre nt1!$B$2:$B$60000=$D$9)*( Current1!$C$2:$C$60000=$D$10),0)),4)
I have 11 subsequent "Current" sheets numbered in sequence. So naturally i tried

=INDEX(Current1:Current11!$A$2:$D$60000,(MATCH(1,(Current1:Current11!$A$2:$ A$60000=$O11)*(Current1:C urrent11!$B$2:$B$60000=$C$9)*(Current1:Current11!$C$2:$C$60000=$C$10),0)),4 )
but this is returning a "#VALUE"

Any thoughts?
Can I perhaps use vba to get this taken care of?

[Paul_Hossler]

Does this have to be 'array entered'?

Select the formula and Ctrl+Shift+Enter. Excel will put { } around for you.

Paul

[Vioman]

Yea,
I do enter the formula as an array but i was wondering if there is any one doing this from a vba perspective?

[mikerickson]

Without reference to those formulas, what are you trying to do?

[Vioman]

I have data that is inserted by binary into the workbook. I have written code that when the data gets pulled it creates as many new sheets as necessary. I then have to evaluate the data using the index and match based on three criterias. I can index and match on one sheet but I am haveing a problem doing it on multiple sheets