Forum Discussion
Display the selected text as number on a drop down list
Hi Mishu
Unfortunately, you can't make it put a different value in the same cell, so the drop down would be in one column and the corresponding number value would be in another column.
So if you pick from the drop down in cell AE4, you then need a formula in AF4 (or out of the way to the far right) that has a formula to pick up the position of that item in the list = MATCH( AE4, Sheet2!$G$3:$G$75 , 0)
What you want is possible but only with getting into the VBA (Macro) side of things, which is a lot more complex to set up properly, e.g. be able to double click in AE4 and have a pop up box and be able to see the full description, pick one, and the resulting figure of 1 etc to be returned into AE4
Hi Mishu
Unfortunately, you can't make it put a different value in the same cell, so the drop down would be in one column and the corresponding number value would be in another column.
So if you pick from the drop down in cell AE4, you then need a formula in AF4 (or out of the way to the far right) that has a formula to pick up the position of that item in the list = MATCH( AE4, Sheet2!$G$3:$G$75 , 0)
What you want is possible but only with getting into the VBA (Macro) side of things, which is a lot more complex to set up properly, e.g. be able to double click in AE4 and have a pop up box and be able to see the full description, pick one, and the resulting figure of 1 etc to be returned into AE4
Thanks Wyn.
Your response and formula has helped me a lot, I truly appreciate your help and support on this.
Please let me know if you come across a solution as depicted by yourself on the trailing response (VBA- Macros) to display the value in the same column (AE).
Regards,
Mishu