View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ruth Ruth is offline
external usenet poster
 
Posts: 132
Default Please let me know how to do a lookup

I have a data base that I need to enter the distance between 2 locations.

ei


From To NT
KM
Windsor Detroit 15476.5936
2
Windsor Detroit 15709.2
2
Windsor Detroit 15886.6864
2
Meldrum Bay Muskegon 5000 541
etc...

I have a table that gives the distance between two places.

ei

From To KM
Badgeley Island Midland 206
Burns Harbour Port Colborne 1340
Burns Harbour Sarnia 919
Burns Harbour Sault Ste Marie 690
Bruce Mines Bay City 390
etc...

I tried the following formula to look up the distance

=VLOOKUP(E6:F6,'Distance Key'!A2:C163,3)

But it didn't work.

How is this done?

--
:)