Hi,
Is there a way we can include If and Vlookup in a drop-down list?
Example :
List of Roles : NA, System Eng
Competency : List, C1/C2
When selecting NA there should be a drop-down which give 20 different values but when there is anything else but NA, a vlookup will give an exact match to that role.
Please help.
Thank you!
Last edited by RashmiD2930; 07-31-2020 at 06:32 AM.
Please post a sample sheet ( see yellow banner)
PFA a sample, thanks!
Create multiple linked dropdown list in excel
http://helpdeskgeek.com/office-tips/...ists-in-excel/
http://thefinch.wordpress.com/2008/0...datavalidatie/
http://www.contextures.com/xlDataVal02.html
http://www.snb-vba.eu/VBA_Afhankelijke_validatie.html also in Englisch
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you for reverting.
Couple of links are not available, may be they are country specific.
The other two are dependent drop-downs.
I want to add an IF and VLOOKUP functions and create a DataValidation-Drop-down.
For cell C4 you want a dependent drop-downlist.
In the link(s) is explained how you can make them.
For the other option you can make also a dependent drop-downlist.
I am afraid, thats not giving me the right solution.
Could you please use my sample sheet and share your solution.
Thanks!
Hello Rashmi,
I am not sure is this you needed.
Use the below formula in the data validation Source: then apply to other cells.
=INDEX($P:$P,MATCH(C4,$O:$O,0))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thanks Haseeb. But this formula I've already used in Data Validation and it gives one to one value.
I want a drop down from Column P3:P7 when C4 is NA in Cell D4.
Is there a way to this in Cell D4 - If(C4 = "NA", Dropdown(from col P), else vlookup(C4 in column P)
@Haseeb;
In case of cell C4 is "NA" then the full list must be populated. So, this may be better;
Please Login or Register to view this content.
Try with IF Rashmi,
=IF(C4="NA",P$2:P$7,INDEX($P:$P,MATCH(C4,$O:$O,0)))
This works Haseeb!! thanks a ton!
Best Regards,
Rashmi
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks