Formula issue
Solved
Nathlaly
Posted messages
8
Status
Member
-
Nathlaly Posted messages 8 Status Member -
Nathlaly Posted messages 8 Status Member -
Hello,
Can you help me please?
I created a table
https://mon-partage.fr/f/zhs7kzaI/
that includes data according to the person, but I would also like it to fetch data based on the months...
Here is my formula that gives me what I need and works very well, but I want "JANV" to change automatically to "FEB" or "MAR" if I select the corresponding month.
=IF(COUNTIF(INDEX(JANV,L9C1,2),"*/*"),LEFT(INDEX(JANV,L9C1,2),3),IF(INDEX(JANV,L9C1,2)="","",(INDEX(JANV,L9C1,2))))
I created a combo box (L8C1) for month selection, but I am lost from here!!!
Can you help me?
Can you help me please?
I created a table
https://mon-partage.fr/f/zhs7kzaI/
that includes data according to the person, but I would also like it to fetch data based on the months...
Here is my formula that gives me what I need and works very well, but I want "JANV" to change automatically to "FEB" or "MAR" if I select the corresponding month.
=IF(COUNTIF(INDEX(JANV,L9C1,2),"*/*"),LEFT(INDEX(JANV,L9C1,2),3),IF(INDEX(JANV,L9C1,2)="","",(INDEX(JANV,L9C1,2))))
I created a combo box (L8C1) for month selection, but I am lost from here!!!
Can you help me?
1 answer
-
Hello
Joaspi, what is the point of sending a message to respond no????
Nathalaly:
to keep it simple in your model, it is better to replace your selector (linked to cell A8) with a dropdown validation directly in a cell, for example in cell J
2
The dropdown validation will provide a choice between the list of fields you named JANV FEV and probably the others to follow
Then you just need to replace in the formulas JANV with INDIRECT($J$2) and they will adjust to the field name displayed in J2.
But if you want to keep this system, you need to place a formula for example still in J2
=CHOOSE(A8;"JANV";"FEB";"MARCH"; etc....)
But it is far from simpler
best regards
