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