View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan
 
Posts: n/a
Default how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})

Bill- Thanks so much, the ascending order is the key. You have saved me hours!

"William Horton" wrote:

You would have to split your range up into 2 columns. Ex. Starting Range and
Ending Range. Assuming your Starting range is in column A, Ending range in
column B, and price in Column C the below formula will work IF THE RANGES ARE
SORTED IN ASCENDING ORDER.

=VLOOKUP(LOOKUP(E2,A2:A7),A2:C7,3,TRUE)

I only went down to row 7.
Hope this helps.

Bill Horton

"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)