Sep 15 2022 02:59 AM - edited Sep 15 2022 03:24 AM
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...
Sep 15 2022 03:40 AM
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.
Sep 15 2022 03:49 AM
Sep 21 2022 05:02 AM - edited Sep 21 2022 05:30 AM
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
Sep 15 2022 04:31 AM
Solution