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