Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question on Lookup
I don't know anything about the lookup function but I suspect it is the
answer to my question. Here is my problem: I have a list of 5000 student names and addresses (file #1). I have another list of addresses and distances from a school (file #2). My goal is to be able to somehow link file #1 to file #2 and "lookup" the distance by matching up the addresses. How can I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question on Lookup
On Mar 6, 7:31 pm, CJN wrote:
I don't know anything about the lookup function but I suspect it is the answer to my question. Here is my problem: I have a list of 5000 student names and addresses (file #1). I have another list of addresses and distances from a school (file #2). My goal is to be able to somehow link file #1 to file #2 and "lookup" the distance by matching up the addresses. How can I do this? This could be as simple as just a call to VLOOKUP or complex enough to require pattern matching libraries and VBA expertise. It all depends on how your addresses are structured in the two files. Do you have exact matches (i.e. the addresses in file2 appear the same as those in file1)? Is the address broken down to street, number etc? You have to be more specific. HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question on Lookup
The addresses in file 1 & file2 are identical.
"vezerid" wrote: On Mar 6, 7:31 pm, CJN wrote: I don't know anything about the lookup function but I suspect it is the answer to my question. Here is my problem: I have a list of 5000 student names and addresses (file #1). I have another list of addresses and distances from a school (file #2). My goal is to be able to somehow link file #1 to file #2 and "lookup" the distance by matching up the addresses. How can I do this? This could be as simple as just a call to VLOOKUP or complex enough to require pattern matching libraries and VBA expertise. It all depends on how your addresses are structured in the two files. Do you have exact matches (i.e. the addresses in file2 appear the same as those in file1)? Is the address broken down to street, number etc? You have to be more specific. HTH Kostis Vezerides |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question on Lookup
I have been experimenting with the use of teh VLOOKUP function. I have ti
working when I am looking up wihtin the the same file. As soon as I lookup in a different file I get a "#N/A" error. Does this mean that lookps don't work with separate files? "vezerid" wrote: On Mar 6, 7:31 pm, CJN wrote: I don't know anything about the lookup function but I suspect it is the answer to my question. Here is my problem: I have a list of 5000 student names and addresses (file #1). I have another list of addresses and distances from a school (file #2). My goal is to be able to somehow link file #1 to file #2 and "lookup" the distance by matching up the addresses. How can I do this? This could be as simple as just a call to VLOOKUP or complex enough to require pattern matching libraries and VBA expertise. It all depends on how your addresses are structured in the two files. Do you have exact matches (i.e. the addresses in file2 appear the same as those in file1)? Is the address broken down to street, number etc? You have to be more specific. HTH Kostis Vezerides |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question on Lookup
Hi CJN,
I guessing a bit here, but if the "other file" is in another workbook, then your formula will need to look something like this. The other file is in workbook 2 in this case. =VLOOKUP(E1,[Book2]Sheet1!$A$1:$B$5,2,0) HTH Regards, Howard "CJN" wrote in message ... I don't know anything about the lookup function but I suspect it is the answer to my question. Here is my problem: I have a list of 5000 student names and addresses (file #1). I have another list of addresses and distances from a school (file #2). My goal is to be able to somehow link file #1 to file #2 and "lookup" the distance by matching up the addresses. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Question | Excel Worksheet Functions | |||
Lookup question | Excel Discussion (Misc queries) | |||
LOOKUP question | Excel Worksheet Functions | |||
lookup question | Excel Worksheet Functions | |||
Lookup Question | Excel Worksheet Functions |