Forum Discussion
If and vlookup in Data Validation
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.
Thanks for sharing the excel, however we have only one column and we need to get dropdown as well vlookup in one go. Please advise.
The only other thing I could suggest is to use vba to add the data validation for code 17 or perform the lookup and put the value in.