Question on Lookup

C

CJN

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

vezerid

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?
Click to expand...

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
 
C

CJN

The addresses in file 1 & file2 are identical.

vezerid said:
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
Click to expand...
 
C

CJN

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

L. Howard Kittle

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
 
Top