Number to be like in colum A, if number in colum B and C are like

[Kjetil]

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)

[Ardus Petus]

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

HTH
--
AP

"Kjetil" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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)