I need to create a dropdown list in Excel 2011. In one of my worksheets I have 2 columns as follows:
1 Size group a
2 Size group b
3 Size group c
4 Size group d
The first column will just contain numbers while the second column holds the text. I need a way to create a dropdown menu so that I see both columns in the dropdown but when I choose one of the items in the drop down, I only want the number in the first column to appear in the cell.
I just wondered if there is anyway to do this in excel without using user forms?
Appreciate any advice.