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?

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

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

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

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?