Scarlet_Buckeye

Senior Member

5,264 posts

Scarlet_Buckeye

Senior Member

5,264 posts

Mon, Aug 29, 2011 8:50 AM Aug 29, 2011 8:50 AM

I have two Excel spreadsheets...

In Spreadsheet 1, I have a list of names in Column A....

In spreadsheet 2, I have the same list of names in Column A, but in a different order than spreadsheet 1.

In spreadsheet 2, I have another column (let's call it Column D), that I want to marry spreadsheet 1.

So for instance....


Jim Smith Kevin James 2
John Tree Len Berry 22
Lynn Tom Jim Smith 43
Ted Ron Lynn Tom 51


Can someone please help me with the formula?! I know there is one, I just can't remember it.

Thanks!

Aug 29, 2011 8:50am

Jawbreaker

Senior Member

J

520 posts

J

Jawbreaker

Senior Member

520 posts

Mon, Aug 29, 2011 8:52 AM Aug 29, 2011 8:52 AM

Are you looking for something like this?

http://www.digdb.com/excel_add_ins/join_merge_tables_lists/

Aug 29, 2011 8:52am

bases_loaded

Senior Member

6,912 posts

bases_loaded

Senior Member

6,912 posts

Mon, Aug 29, 2011 8:55 AM Aug 29, 2011 8:55 AM

I can't wait for Battlefield 3 to come out. Got mine preordered on Amazon!

Aug 29, 2011 8:55am

OneBuckeye

Senior Member

5,888 posts

OneBuckeye

Senior Member

5,888 posts

Mon, Aug 29, 2011 8:57 AM Aug 29, 2011 8:57 AM

vlookup?

Aug 29, 2011 8:57am

Scarlet_Buckeye

Senior Member

5,264 posts

Scarlet_Buckeye

Senior Member

5,264 posts

Mon, Aug 29, 2011 9:28 AM Aug 29, 2011 9:28 AM

OneBuckeye;876315 wrote:vlookup?

VLookUp is what I have used in the past, I just can't remember the correct coding for it.

Aug 29, 2011 9:28am

OneBuckeye

Senior Member

5,888 posts

OneBuckeye

Senior Member

5,888 posts

Mon, Aug 29, 2011 9:32 AM Aug 29, 2011 9:32 AM

Scarlet_Buckeye;876332 wrote:VLookUp is what I have used in the past, I just can't remember the correct coding for it.

vlookup(Valuesheet1,Array sheet2 A : D,column to retrieve 4,false)

Aug 29, 2011 9:32am

Rider_In_Ttown

Senior Member

246 posts

Rider_In_Ttown

Senior Member

246 posts

Mon, Aug 29, 2011 11:03 AM Aug 29, 2011 11:03 AM

Vlookup is definately the right formula to use.

Aug 29, 2011 11:03am

Scarlet_Buckeye

Senior Member

5,264 posts

Scarlet_Buckeye

Senior Member

5,264 posts

Mon, Aug 29, 2011 11:32 AM Aug 29, 2011 11:32 AM

OneBuckeye;876315 wrote:vlookup?

VLookUp is what I have used in the past, I just can't remember the correct coding for it.

Aug 29, 2011 11:32am

sportswizuhrd

Senior Member

S

3,215 posts

S

sportswizuhrd

Senior Member

3,215 posts

Mon, Aug 29, 2011 4:54 PM Aug 29, 2011 4:54 PM

Kevin James is a horrible actor/comedian. Not sure about John Tree.

Aug 29, 2011 4:54pm