creating formula to return one of several values

[Lawrence]

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?

 

[Gary''s Student]

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

 

[Pete_UK]

Not a lot to go on, but you can set up a table like this:

7 1/4"
13 1/2"
19 3/4"
25 1"
etc.

Suppose you put this in L1:M7, then you can put this formula in B1:

=VLOOKUP(A1,L$1:M$7,2)

to return the appropriate size, assuming the dollar value is in A1.

Hope this helps.

Pete

 

[Shane Devenshire]

Hi,

Why don't you show us sample data and what you want it to look like. Parse
means break apart and you don't want to break 7.00 apart or do you?

This may be what you are looking for: You could create a lookup table with
cost in cells H1:H7 and fractions in I1:I7 then

=VLOOKUP(A1,H$1:I$7,2,)

where A1 contains the value you want to look up, ie. 7.00.

 

[Lawrence]

Thank you very much - this solution worked perfectly!

Happy New Year!