Look-up (match) and merge data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

?Info? - 22 May 2008 21:50 GMT

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.

Reply to this Message

Max - 22 May 2008 23:56 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message