Thread
:
how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})
Best to use VLOOKUP instead of lookup for this. Use your table
--
Don Guillett
SalesAid Software
"Susan" wrote in message
...
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)
Reply With Quote