Excel Help

• Scarlet_Buckeye

  

  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!
• Jawbreaker

  Are you looking for something like this?
  
  http://www.digdb.com/excel_add_ins/join_merge_tables_lists/
• bases_loaded

  

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

  

  vlookup?
• Scarlet_Buckeye

  

  OneBuckeye;876315 wrote:vlookup?

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

  

  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)
• Rider_In_Ttown

  

  Vlookup is definately the right formula to use.
• Scarlet_Buckeye

  

  OneBuckeye;876315 wrote:vlookup?

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

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