Look-up (match) and merge data
 

I need to match a column on two sheets. Then use that match to pull over
multiple other cells related to that matched cell. For example: Each Sheet
contains employee IDs, but sheet 2 also contains there First & Last name,
Date of Employment, etc. Each Data point on the same line but in different
columns. I've already tried vlookup but I can only bring over one data
point, and not multiples at the same time.

Look-up (match) and merge data
 

Indicatively: =Trim(vlookup(2)&" "&vlookup(3))
where 2,3 are the col indexes for first & last names
would return the desired concatenation of the first & last names
which is also trimmed of any extraneous white spaces
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"?Info?" wrote:
I need to match a column on two sheets. Then use that match to pull over
multiple other cells related to that matched cell. For example: Each Sheet
contains employee IDs, but sheet 2 also contains there First & Last name,
Date of Employment, etc. Each Data point on the same line but in different
columns. I've already tried vlookup but I can only bring over one data
point, and not multiples at the same time.