Forum Discussion
Nagaraj007
Dec 08, 2020Copper Contributor
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 the screen snip for your reference.
Sheet 1 | sheet2 | |||||||
Year | Quarter | code number | Column1 | codenumber | d | |||
2020 | Oct-Dec | 17 | if code number 17 selected from drop down it should show drop down of mm, mc else vlookup | 11 | mc | |||
12 | mc | |||||||
13 | mm | |||||||
14 | mm | |||||||
15 | mm | |||||||
16 | mm | |||||||
17 |
13 Replies
- TwifooSilver Contributor
- Nagaraj007Copper Contributor
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?
- TwifooSilver ContributorI 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.
- Nagaraj007Copper Contributor
- Riny_van_EekelenPlatinum Contributor
Nagaraj007 Begin by uploading your file (remove any private and confidential information), rather than cut and paste a table that doesn't seem to represent your actual file.
- Nagaraj007Copper Contributor