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