I've got two Excel sheets containing data about employees. Sheet A is
a complete list, and Sheet B is a shorter list with only employees who
are in a certain job category. I need to compare the two lists--both
have Employee ID numbers as part of the data set. Where Excel finds a
matching ID #, I would like to append the job title that appears in
Sheet B into a blank column on Sheet A.

I'm thinking this could be done with some combo of an IF statement and
VLOOKUP, but I haven't gotten any further than that. Any help would
be greatly appreciated!

Depending on how that table on sheetB is laid out, you could use =vlookup() or
=index(match())

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

"E. L." wrote:

I've got two Excel sheets containing data about employees. Sheet A is
a complete list, and Sheet B is a shorter list with only employees who
are in a certain job category. I need to compare the two lists--both
have Employee ID numbers as part of the data set. Where Excel finds a
matching ID #, I would like to append the job title that appears in
Sheet B into a blank column on Sheet A.

I'm thinking this could be done with some combo of an IF statement and
VLOOKUP, but I haven't gotten any further than that. Any help would
be greatly appreciated!

--

Dave Peterson