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,
|