Thank-you very much, we will try it!
--
Thank-you!
Ruth


"daddylonglegs" wrote:

Presumably then you also need to use the start point in the formula to get
the correct distance so try

=LOOKUP(2,1/((startpoint_range=startpoint)*(loadpoint=loadpoin t_range)*(unloadpoint=unloadpoint_range)),distance _range)

"Ruth" wrote:

Hi

We have a data base that has columns such as start point, load point and
unload point with the distance between each in a separate column. We want to
create a column that will look up the load point and unload point and give us
the distance. The problem is that the load point and unload point are often
times listed up to 5 times, as the start point is different, so the formula
we are using

SUMPRODUCT(table range=cell)*(table range=cell)*(table)

is summing the distances.

What is a formula we can use that will not add the distance together?
--
Thank-you!
Ruth