Hi,

Using the dav idea of just starting values, you could use an array formula
for this. Supposing the prices are in column D, and the list with the
starting values and the prices goes from A1 to B36, you could use this array
formula in cell E1:
=MAX(IF(D1$A$1:$A$36,$A$1:$A$36))
Remember to enter it with Ctrl+Shift+Enter. Enter it on the first cell and
then copy and paste to the others in the column.
You can after that use a Vlookup formula in column F
=VLOOKUP(E1,$A$1:$B$36,2)

Miguel.

"Susan" wrote:

Hi-
I thought Bill had it solved, but I have approximately 600 prices & while I
can sort them in ascending order, I cannot match them to a 36 element table.
Here is a sample of how the prices may look. Where the cost falls in the
range determines the price charged. I tried using IF statements (
0A2<1.01,6, ) but could only use 7 & I have 36 price ranges. Thanks again,
Susan
.1718
.7103
1.4386
.0461
.1069
.2766
.0289
.0391
.1517
.0230
.0849
1.1668
.2588
.1215
.0598
.0080
.1040
5.4230



"Dav" wrote:


if the startuing values are entered a vlookup should suffice, something
like

0 5
0.01 6
1.01 7
2.01 10
5.01 12
7.01 15

If your cell value to lookup is in c1 something like the following
should work

vlookup(c1,$a$1:$b$36,2)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=535575