| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? -- :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Threaded Mode
