Comparing two workbooks.

K

Kevin Porter

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.
 
M

Max

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
 
Top