Forum Discussion
If and vlookup in Data Validation
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.
I don't know if it's an option, but you could set up an input column only for Code 17 that uses data validation (Indirect function) to reference a named range of options for Code 17 (the "mc" and "mm"). So, when the input value is not 17, the data validation drop box won't work.
Then, in another cell, use an IF statement to pull the value from the drop down cell when the input =17 or vlookup for all other values.
I attached a file to illustrate.
Twifoo ,
Hi, If you could show me in the same excel which you provided it would be useful. As i am very new to this formulas.
