A B X Y Z AX AY AZ Bx BY BZ
1 0 0 1 0 0 1 0 0 0 0
1 0 1 0 0
1 0 0 0 1
0 1 0 1 0
0 1 1 0 0
0 1 0 0 1

this is the for ex. first row and colum now i want this kind of formula in
AX, AY, AZ, BX, BY, BZ. answer will come 1 in AY and in others will come 0.
which kind of formula i have write?

try this

in cell F2 put this formula
=IF((LOOKUP(LEFT(F$1,1),$A$1:$E$1,$A2:$E2)*LOOKUP( RIGHT(F$1,1),$A$1:$E
$1,$A2:$E2))=1,1,0)

copy it down and across.


On Jan 28, 3:31*pm, Chintan wrote:
A * * *B * *X * * Y * *Z * *AX * *AY * *AZ * *Bx * * BY * *BZ
1 * * *0 * *0 * * *1 * *0 * * 0 * * *1 * * *0 * * 0 * * *0 * * * 0
1 * * *0 * *1 * * *0 * *0
1 * * *0 * * 0 * * 0 * *1
0 * * * 1 * *0 * * 1 * *0
0 * * * 1 * *1 * * 0 * *0
0 * * * 1 * *0 * * 0 * *1

this is the *for ex. first row and colum now i want this kind of formula in
AX, AY, AZ, BX, BY, BZ. answer will come 1 in AY and in others will come 0.