Match two columns of names while keeping data in rows aligned

**SpaceWheels** · 03-27-2013, 12:32 PM

I have six columns with the following headings and I want to use a formula to match up the Person Names while keeping the rows of data attached to the names aligned.

A B C D E F
Store Lic# Name1 Name2 ID StoreName

Column's A, B, C contain 1000 rows of records and columns D, E, F contain 1500 rows of records. If the names in C2 & D2 match the rows with their corresonding data should line up.

But if the name in C2 does not match D2 but does match D3, then D2 should be BLANK and C2 would line up with D3.

I spent all day yesterday aligning the names by hand only to discover the attached rows did not stay aligned. Huge mess.

I would appreciate any help proided.

Thank you

**FDibbins** · 03-27-2013, 12:35 PM

Hi and welcome to the forum

Im thinking that you probably need to use vlookup() or index/match() for this, but fi you could upload a sample (without sensitive info), I could give a better result...

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**SpaceWheels** · 03-27-2013, 01:00 PM

I have attached a sample file.

Thanks,

**bebo021999** · 03-27-2013, 01:09 PM

Try it in G2:
=VLOOKUP($C2,$D$2:$F$13,2,0)
H2:
=VLOOKUP($C2,$D$2:$F$13,3,0)
Drag down.
Copy/paste value column G and H
Delete D,E,F column.
Hope it works.

**SpaceWheels** · 03-27-2013, 01:24 PM

Thanks. I will give it a try.

**SpaceWheels** · 03-27-2013, 01:40 PM

FDibbins,
The formula didn't work quite right.

The name in column C is looking for a match in column D.
If it finds a match in column D the name in column C should line up with the name in column D and bring the information in column A & B as one record, (A,B,C).

Thanks,
SpaceWheels

**FDibbins** · 03-27-2013, 01:45 PM

That was bebo's formula, not mine?

**SpaceWheels** · 03-27-2013, 01:46 PM

Oops,
Sorry about that.

**popipipo** · 03-27-2013, 01:57 PM

Take a look at this.
The green cells is what your looking for.

**SpaceWheels** · 03-27-2013, 02:22 PM

I have plugged in the formula but I don't know how to start it.

Match two columns of names while keeping data in rows aligned

LinkBack

Thread Tools

Rate This Thread

Display

Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Re: Match two columns of names while keeping data in rows aligned

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions