lookup prblem.

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 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top