substitution
 

dear gentleman,

There is a list of values f.e. 1 till 38, these values will repeat
themselves..in the list. I would like to assign a number to each of these
values, the thing is, the list of values is long and mixed. So I want for
excel to do it for me. how can this be done?

f.e. value 15 is assigned the number 10 and thus every time it is met on the
list excel will assign the number 10 for to value 15. who can help me with
this?

substitution
 

Off to the side of your data, or on a separate sheet of your workbook,
create a table of the numbers that you want to assign to each value

e.g.

Cell AA11 = 10, Cell AB11 = 15
Cell AA12 = 11, Cell AB12 = 16



If your numbers from 1 to 38 are in Column A
Then, as an example, your formula in Cell B2 would be
=Vlookup(A2,$AA:$AB,2,FALSE)


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=548229