Copying value from different column - complex formula - Excel

Good morning,

I am trying to create a new column ( example below" created " column is the result I would like to get ). The new column should copy the value of the " DEN" column for each KPI ( taking into account the MARKET except for the KPI "NNS Aff" where it should change the value instead of zero it should take the value of NNS for the appropriate market.

There is many different markets so the formula should take the market into consideration.

Best regards,

Bonjour,

In french please ...

ric

Bonjour à tous,

Une proposition :

Merci,

Cela marche parfaitement cependant, j'aimerais rajouter une condition supplémentaire telle que - table[time]= table [@time ] en plus de la condition de les markets. Ce qui donnerait quelque chose dans le genre :

=IF([@KPI]<>"NNS Aff";[@Den];INDEX([Num - Calc];MATCH(1;(AND( ([KPI]="NNS")*([Market]=[@Market])e],[KPI="NNS"]*[time]=[@time]);0)))

Une erreur,

=IF([@KPI]<>"NNS Aff";[@Den];INDEX([Num - Calc];MATCH(1;([KPI]="NNS")*([Market]=[@Market])*([Period Type]=[@[Period Type]]);0)))

Voici la nouvelle formule, j'ai rajouté une condition sur le periode type

Si tu as terminé, marque en résolu.

Crdlmt