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