software

How can i get the number of column A to show if column B and C are like in
diferent rows?

A B C D

1 33221 4131 4000 (value of A3)
2 33311 4400 4131 (value of A1)
3 33123 4000 4400 (value of A2)

In D1 (then copy down):
=INDEX($A$1:$A$3,MATCH(C1;$B$1:$B$3;0))

HTH
--
AP

quot;Kjetilquot; gt; a écrit dans le message de
...
gt; How can i get the number of column A to show if column B and C are like in
gt; diferent rows?
gt;
gt; A B C D
gt;
gt; 1 33221 4131 4000 (value of A3)
gt; 2 33311 4400 4131 (value of A1)
gt; 3 33123 4000 4400 (value of A2)