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