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 ite...
Yes.
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.
Hello Sir,
Last solution of question which you have given suggestion is very helpful.
And i apologize that i ask so many questions.
Before i ask question here, first of all i will try,
and If i do not get solution then i will ask question here.
I respect you a lot sir which you guide me.
Please please please forgive me sir
I am very very sorry
