Look-up (match) and merge data

[?Info?]

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.

 

[Max]

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