Hi,

I got an issue which i need some help with if possible:

I've got a selection of drop down lists and used the =CONCATENATE command to bring all the options picked into one cell. I've then used the =VLOOKUP command to pull the information from an array in another worksheet which matches the info in the =CONCATENATE cell.

I was wondering if it was assign a number to the options in the drop down list that the =CONCATENATE cell can display rather than the text choose?

for example if option one was "RED", option two was "BALL" and three was "HALLWAY", can i assign "1" to RED, "2" to BALL and "3" to HALLWAY, so the =CONCATENATE cell displays 123, rather than REDBALLHALLWAY.



It would make my array so much easier to set up as some of the strings needed from the options could turn out like war and peace in the =CONCATENATE cell otherwise.

Is this possible? Any suggestions appreciated...

Thanks

Just as a casual observation, it may be easier for folks to understand what you are trying to accomplish if you provided an example. Also not quite clear you would want to enter text first, then convert to numbers, why not just enter numbers first? You know better what it is that you want to accomplish, we don't, and therefore is hard for us to imagine unless everything is super crystal clear. See?

Hi,
MATCH function returns the position of the selected option in list, which is exactly what is needed in this case, we can use the position to associate a number to a selection. If we want to change the number associated to a selection, this can be done by simply rearranging the list!
Test the attached file, let me know if this is what you needed.
Cheers,

Attached Files

Example.xlsx (9.7 KB, 8 views)