Thank you very much - this solution worked perfectly!

Happy New Year!



"Gary''s Student" wrote:

For example:
=LOOKUP(A1,{7,8,9,10,11,12;"1/4","1/2","2/3","1","1 and 1/4","1 and 1/2"})
so if A1 contains 12 ( or 12.00)
then the formula displays:
1 and 1/2
--
Gary''s Student - gsnu200823


"Lawrence" wrote:

Have column with dollar values that correspond to fractions representing
thickness of materials (ie cell shows $7.00 - which is the cost of 1/4"
material)
I want to create another column which will parse the cell with the dollar
value and enter the corresponding fractional value for material thickness
based on the 6 different cost values that could be in the cell and the
related fraction that I want to be populated in the cell of the new column.
How do I create this formula?