Vioman
06-14-2011, 03:30 PM
: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?
=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?