View original (French)

What function to perform in B1 related to A1

Aziz -  
Frenchie83 Posted messages 2254 Status Membre -
Hello,

Configuration: Android / Chrome 78.0.3904.108Hello everyone. I have a problem in Excel, I have two cells A1 and B1. I don’t know how to do it: if A1=1 then in B1 I have to choose from 1 to 6, and if A1=2 then in B1 I have to choose from 7 to 8. This is how I need to create a drop-down list. Please help me.

1 réponse

Réponse 1 / 1
Frenchie83 Posted messages 2254 Status Membre 339
 
Hello,

With the description of what needs to be done


the example file
https://mon-partage.fr/f/VcVT6gSe/

Make your selection in A1, the corresponding list displays in B1

Best regards
0