If function help

[Vince_J]

I have a problem for selecting the proper delay per activity depending its status.
My 1st colum will be the current status for each activity (4 status possible). Then i have 3 other column (delays) per status.
I would like to select the proper delay depending its current status and add another exception. If it's a status closed, i just want a blank result.

I think, it related to SOMME.SI.ENS in french which is SUMIFS in english.
- How could i make the right conditional formula ? please

Thank you,
Best regards,

Vince

[#2]

You may CHOOSE a formula similar to this in E2:
=CHOOSE(MATCH(A2,
{“Open”,”Starting”,”Pending”,”Closed”},0),
B2,C2,D2,””)

[#3]

@Twifoo 

I am not very familiar to this function.

- Could you elaborate your explanation ? please

Thank you,

Vince

[#4]

MATCH returns the index_num argument of CHOOSE and finds the position of the status in A2, in the sequence Open, Starting, Pending, and Closed. If index_num is 1, 2, 3, and 4, CHOOSE returns the value in B2, C2, D2, and empty text (“”), respectively.