On a spreadsheet, based upon the content in column A, the correct range must be selected from the content in B.
A = 1 h, 2 h, 3 h, 4 h ... 23h, 1d ... 1 w, ... 1m, ...1 y, 2 y ... 15 y B = 0-2yr, 2-5yrs,5-10yrs,10-15yrs,>15yrs
At present, the data in both columns is entered manually. I'm in the middle of defining both as a list to make the data relatively more consistent; hence this question.
It's possible ( and error-prone, I'm sure ) to perform the match by first parsing each entry in A, and then matching the value to the available options in B after parsing those too.
Is there a way to define a key-value pair in excel such that the A shows the list with content as above, but the value selected and used internally is something different altogether?( the way a combo-box/List may be defined in java, and it's ilk )