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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Number to be like in colum A, if number in colum B and C are like (https://www.excelbanter.com/excel-worksheet-functions/79484-number-like-colum-if-number-colum-b-c-like.html)

Kjetil

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

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

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

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

HTH
--
AP

"Kjetil" a écrit dans le message de
...
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)

All times are GMT +1. The time now is 09:55 AM.