IFS function and Cell with a local menu format
Hello
I have a problem with IFS function ( or IF ) :
When I select a line from the pop-up menu (made from the list of months of the year)... I want a cell of another table to be automatically completed according to the chosen value :
example :
If I take janvier--->. it writes 01 in the target cell
If I take mars --->. it writes 03 in the target cell
It seems that NUMBERS is not able to process a formula using the IFS function when referring to an array whose cell is in the "local menu" format.
IFS('Tableau 2-1'::A1="janvier";"01";'Tableau 2-1'::A1="fevrier";"02";'Tableau 2-1'::A1="mars";"03")
can you help me :-)