Take a look at the VLOOKUP function.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"rjdavis" wrote in message
...
I want to enter a name in one worksheet, then have EXCEL search
a seperate
worksheet for the address that matches the name