Forum Discussion
If and vlookup in Data Validation
Hello All, I have a excel where in i want the users to select from dropdown only for one specific number (ex 17) apart from that any number they select it should do vlookup from sheet2. Below is th...
I got the output required as per your excel attachment.
However the problem is i need to add 171 items under name manager. Is there any workaround for this?
- I suggest you find a rule when to choose "mc" of "mm", if the code is 17. Thereafter, you'll need a lookup formula rather than a drop-down list.
Could you please help me? I am waiting as i need to add 171 name managers. If you could send me the excel with the rules that would be of great help.
