Forum Discussion
Solved
Query related to Dropdown list in Excel
Hello Everyone,
Here is a screenshot :
What I want here is when user selects the Drop down list "marked red".
Here I need two things as solution.
1. --- I need to map the Drop down items like -Not started, Completed etc to the Numbers mentioned in Brackets.
2. --- When user selects the Dropdown list, The corresponding number should automatically populate on Column (Rate when option selected). Ex:- 3 populate upon second option (Started and initial phase)
Please explain with example..
Please help...
Yes.
4 Replies
Create a lookup list as in the screenshot below. Here, it is on the same sheet, but it can be on another sheet if you prefer.
The formula in C2 is
=IFERROR(VLOOKUP(B2,$G$2:$H$6,2,FALSE),"")
This can be filled down if required.
- It means that :
1st - i have to create dropdownlist in Option list column.
2nd - Then i have to put formula in C2
then it will come Rate according to Option list.
Is this correct sir ?Yes.
