VLOOKUP function returning data from ranges
Setup your table like this:
List the lower boundary of each range in column B:
..............B...............C
1...........0...............0
2...........1..............50
3..........20.............45
A1 = 26
=VLOOKUP(A1,B1:C3,2)
Or:
=LOOKUP(A1,B1:B3,C1:C3)
Biff
"rayteach" wrote in message
...
I want to use a VLOOKUP function to find data in a table that includes
ranges. Example:
# of tables Cost per table
1 - 19 $50.00
20 - 39 $45.00
If I then type 26 in a cell, $45.00 would appear. I can then have a simple
multiplication formula in the next cell to calculate total cost.
--
ray
|