help with a query ?

[sm]

i have the following table, with the weight on the 1st horizontal line,
the destination postal code on the 1st vertical column, and the rate to
pay for each weight and destination :

weight up to :
10 20 30 40
postal code
25
117.2
135.6
155.0
175.4
26
92.9
99.7
105.5
113.3
53
117.2
137.5
156.9
178.3
90
150.1
166.6
212.2
232.6

I would like to have the on a cell, the price when i give the weight and
the destination, automatically.
for example for a weight of 20 kg and a postal code of 25 --> 135.6
for a weight of 21 kg and a postal code of 25 --> 155.0

i have tried with @lookup but i cannot find the solution.
could you help me with this problem.
Thanks and best regards.
Steve

[RUSS BARTOLI]

This seems to work--- I'm using Lotus R 5.01:

I assume your data is in a grid.

@HLOOKUP(WEIGHT,TABLE,@MATCH(CODE,A2..A5,0)+1)

The table starts in A1 (A1 itself is blank).
I changed the top row headers:

0 9.9999 19.999 29.999 40.0001

from 10 20 30 40

add @NAs under the 40.001 column to enforce the upper limit of 40.

Russ

sm wrote in message <3A93B4AC...@hotmail.com>...