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 ?
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