Put a value to a cell only if two values of two other columns are the same

[antstyl]

Hello everyone,
i tried to search and find what I am looking for but with no success probably because I cannot describe it very well. I will try to explain what I need with a picture.
Thanks for your assistance in advance.

 

[tyija1995]

In cell K2 try this and drag it down:

=IF(SUMPRODUCT((I2=$D$2:$D$7)*($E$2:$E$7))=0,"",SUMPRODUCT((I2=$D$2:$D$7)*($E$2:$E$7)))

 

[antstyl]

Thanks but it gets me a #VALUE mesage on the cell..
I am not sure still if I have explained it well. I need all the values of the column "orofos" to be put next to the appropriate address_id

 

[tyija1995]

Hey, it is likely to do with the fact that your column I is not numeric - how have you generated column I? and if its generated from column A then how is column A generated?

 

[antstyl]

Column A is generated from a database export and column I is a copy of column A.
But I have changed the format to Number and no change.

Will it help if i attach the excel file?

 

[tyija1995]

If changing col I to numbers did not work then sure go for it - as long as there's no sensitive information being attached!

 

[antstyl]

Please download a sample from the below.

https://ufile.io/2nbk6se8

 

[tyija1995]

Hey,

I had a look at this, it had greek symbols in it, assuming that's fine(?)

I put the formula in column L

L2:

IF(SUMPRODUCT((J2=$F$2:$F$21)*(ISNUMBER($G$2:$G$21)))=0,"",INDEX($F$2:$G$21,MATCH(J2,$F$2:$F$21,FALSE),2))

It only picked up where the ID was 43 (and so it should according to the sheet I saw)

 

[antstyl]

First of all thanks for your help.

I tried it but it gives me the below.

 

[antstyl]

I have run again the formula from another computer and it doesn't popup any error but the result is empty cells.

Please find here below the same excel with the formula that you gave me in L column.

https://ufile.io/rezs7a5k