I give up! I am trying to compose & inadvertently am posting...time to go
home & sleep over this puzzle

Column A will have the price ranges, column B will have the fixed prices.
I'd like to drop in the costs from our vendor into column C and in column D,
have the formula applied from the 36 element table. I want to either hide
this table or keep it on a second sheet, the second sheet is my preference
since I want to have 2 individual price tables of about 600 items each.
I am only semi-literate w/ Excel, & hence these next questions: does x
refer to the cell with my vendor cost, in this case C? & The 2 statements of
"-", what am I asking here? or should I substitute something for those value?
My final sheet should read acq cost = 0.83, price=$6.00.
I really appreciate your help with this.
Susan

"Harlan Grove" wrote:

Susan wrote...
I am trying to use a lookup formula to calculate the price, The dollar
amount could be from zero on up to $150.00. Can this be done as a lookup?
Thanks so much for any tips.
Regards, Susan

range price
0 $5
0.01-1.00 $6
1.01-2.00 $7
2.01-5.00 $10
5.01-7.00 $12
7.01-10.00 $15
up to
145.01-150.00 $155 (table contains 36 values)

If the table above were in A1:B37 with the column labels in A1:B1 and
the ranges as text in A2:A37, then you could use LOOKUP as long as the
low ends of the ranges are in ascending order.

=LOOKUP(x,--MID(A2:A37,1,FIND("-",A2:A37&"-")-1),B2:B37)