Beatrix
08-16-2013, 10:19 AM
Hi Everyone ,
I need to index an array like C3:P38 obviously below formula is not right way to do it. Is there a formula to do this or I have to re organise data in worksheet Exc:think: ? I attached a sample workbook to clarify what I am trying to achieve. Please see column x in sp
=IF(ISNA(INDEX(Exc!$C$3:$P$38,MATCH(1,((Exc!$A$3:$A$38=$B$2)*(Exc!$C$2:$P$2 =$B9)*(Exc!$B$3:$B$38="FIXD")),0))),"",INDEX(Exc!$C$3:$P$38,MATCH(1,((Exc!$A$3:$A$38=$B$2)*(Exc!$C$2:$P$2=$B9)*(E xc!$B$3:$B$38="FIXD")),0)))
Cheers
Yeliz
I need to index an array like C3:P38 obviously below formula is not right way to do it. Is there a formula to do this or I have to re organise data in worksheet Exc:think: ? I attached a sample workbook to clarify what I am trying to achieve. Please see column x in sp
=IF(ISNA(INDEX(Exc!$C$3:$P$38,MATCH(1,((Exc!$A$3:$A$38=$B$2)*(Exc!$C$2:$P$2 =$B9)*(Exc!$B$3:$B$38="FIXD")),0))),"",INDEX(Exc!$C$3:$P$38,MATCH(1,((Exc!$A$3:$A$38=$B$2)*(Exc!$C$2:$P$2=$B9)*(E xc!$B$3:$B$38="FIXD")),0)))
Cheers
Yeliz