I need to look at the data in a particular cell then (employee name) compare
it to a list in another worksheet. When I find the match (employe names
match) I need to read the data in the next cell (office location).

Then I need to take that data (office location) and use it to tell the first
worksheet where to write the information beneath the original cell (it will
be a worksheet named the same as office location).

Any help would be appreciated.

Either VLOOKUP or INDEX/MATCH would serve the purpose here. VLOOKUP is
simplest but requires the lookup col to be the leftmost, with return cols to
the right. INDEX/MATCH provides more versatility, MATCH on any lookup col,
return on desired INDEX col

Suggest you try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kevin Porter" wrote:
I need to look at the data in a particular cell then (employee name) compare
it to a list in another worksheet. When I find the match (employe names
match) I need to read the data in the next cell (office location).

Then I need to take that data (office location) and use it to tell the first
worksheet where to write the information beneath the original cell (it will
be a worksheet named the same as office location).

Any help would be appreciated.