lookup prblem.

[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

 

[Niek Otten]

Hi Motty,

=INDEX(C7:C45,MATCH(C1626,D745,0))

 

[Motty]

Hi Niek,

Thanks for the reply it worked,

Motty