Formula problem

[#1]

Hello fellow QV users,

I have the following case, see matrix below:

CONTRACT	SUB-CONTRACT	PRODUCTCODE	CORRECT CODE
A	1	mt-10	mt-10
A	2	other	mt-10
A	3	other	mt-10
A	4	other	mt-10
A	5	other	mt-10

I have a contract named A and this contract has 5 subcontracts one of these has a productcode 'MT-10' the other sub-contracts are named 'OTHER'. How can I create the result as shown in column CORRECT CODE (every sub-contract should be named (MT-10). Be aware that there are 25 PRODUCTCODES, each contract has one PRODUCTCODE NAME and the other sub- contracts are also named other.

With kind regards,

Aissam

[#2]

Thanks guys,

I will see if it works, can take a few days, but I will let you know. Thanks again.

regards,

Aissam

[#3]

Hi Guys,

It took me a few days but it works, thanks again.

Regards,

Aissam