Formula issue
Solved
Nathlaly
Posted messages
8
Status
Membre
-
Nathlaly Posted messages 8 Status Membre -
Nathlaly Posted messages 8 Status Membre -
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 réponse
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
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
A huge thank you for your insights... it's great, it works... I'm not an Excel expert as a secretary but I love creating these tables to make my work easier and wow... I'm so glad you were able to help me with this issue.
Thank you for your time and knowledge
Best regards
Nathaly