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!

Are you looking for something like this?

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

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

vlookup?

OneBuckeye;876315 wrote:vlookup?

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

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)

Vlookup is definately the right formula to use.

OneBuckeye;876315 wrote:vlookup?

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

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