Assuming the Employee ID is in Column A in both spreadsheets...

=vlookup(A1,Sheet2!A:E,4,false)

Note: A1 = Cell A1 from Sheet 1

Equation also assumes column E (or the 4th column) contains information you
want to bring to Sheet 1.

Hope this helps.. if we had a little more info I think we could be more
descriptive of the solution


"Susan Fernandez" wrote:

I have two speadsheets with a common Employee ID. Both sheets have
information that I would like to combine. Sheet 1 has the list of employees
that I need. Sheet 2 has information that I need to combine with sheet one.
How do I bring them together?