M
Motty
Hi all,
I have a excell sheet with three coloums, origin, destination and
distance. Now i have a got a distance value on the same sheet but
seperate placed i want to get the corressponding destination value for
that distance.
Distance value i am looking up is in cell C1626, i want to display its
corresponding destination in cell B1626. The destinations i am looking
for is between C7:C45 and the distance value is the range D745. I
cannot get the lookup to work here is my formula :
=LOOKUP(C1626,C745,C7:C45). This is not giving the correct result.
Any help very much appreciated thanks in advance,
Motty
I have a excell sheet with three coloums, origin, destination and
distance. Now i have a got a distance value on the same sheet but
seperate placed i want to get the corressponding destination value for
that distance.
Distance value i am looking up is in cell C1626, i want to display its
corresponding destination in cell B1626. The destinations i am looking
for is between C7:C45 and the distance value is the range D745. I
cannot get the lookup to work here is my formula :
=LOOKUP(C1626,C745,C7:C45). This is not giving the correct result.
Any help very much appreciated thanks in advance,
Motty