lookup prblem.
 

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 D7:D45. I
cannot get the lookup to work here is my formula :
=LOOKUP(C1626,C7:D45,C7:C45). This is not giving the correct result.

Any help very much appreciated thanks in advance,

Motty


--
Motty
------------------------------------------------------------------------
Motty's Profile: http://www.excelforum.com/member.php...o&userid=29233
View this thread: http://www.excelforum.com/showthread...hreadid=489566

lookup prblem.
 

Hi Motty,

=INDEX(C7:C45,MATCH(C1626,D7:D45,0))

--
Kind regards,

Niek Otten

"Motty" wrote in
message ...

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 D7:D45. I
cannot get the lookup to work here is my formula :
=LOOKUP(C1626,C7:D45,C7:C45). This is not giving the correct result.

Any help very much appreciated thanks in advance,

Motty


--
Motty
------------------------------------------------------------------------
Motty's Profile:
http://www.excelforum.com/member.php...o&userid=29233
View this thread: http://www.excelforum.com/showthread...hreadid=489566

lookup prblem.
 

Hi Niek,

Thanks for the reply it worked,

Motty.


--
Motty
------------------------------------------------------------------------
Motty's Profile: http://www.excelforum.com/member.php...o&userid=29233
View this thread: http://www.excelforum.com/showthread...hreadid=489566