associating data/text in two rows with a third row, and then “remembering” the data

[Johannes85]

Hello

I have a problem with associating data/text in two rows with a third row, and then “remembering” the data. I have attached a PDF with pictures to better illustrate and explain my problem.

I have incorporated many excel and word files containing info about export countries and companies which export with address info. Each excel/word file corresponds to a country, with a list of the export companies, but the problem is that these lists are not consistent regarding address info.

Example: For Argentina (Row 23) the address in col D is present, but for Australia (row 69) the address info is not!

So what I want is excel to “copy”/”remember” an address by a combination of a company and postal code for each time it is a duplicate in a country.

To use the example above: For Argentina the combination of “Danish Crown” and “6700 Esbjerg” the address is known “Gammelby Ringvej 1”, so when the info from Australia is put in, where the address is missing but the same combination of “Danish Crown” and “6700 Esbjerg” is available I want “Gammelby Ringvej 1” automatically displayed in the address column (D69). I want that for all the unique combinations of “Company” and “Postal code” – in that way I can avoid copy/pasting because excel “remembers” the combinations which are repeated for each country.

Is this somehow possible? Is there a function or do I have to write some kind of formula/code?

Hope anyone can help.

Kind Regards
Johannes