Results 1 to 2 of 2

Merging data from 2 Spreadsheets, vlookup?

Threaded View

Habermas Merging data from 2... 12-17-2011, 10:08 AM
Habermas Re: Merging data from 2... 12-17-2011, 11:11 AM
  1. #1
    Registered User
    Join Date
    12-17-2011
    Location
    Turkey
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Merging data from 2 Spreadsheets, vlookup?

    Hello

    I am a political science ph.d. candidate who is trying to compile a dataset on voting turnout in democracies around the globe. I have two spreadsheets: one with country name, election year, and voting turnout. The other spreadsheet with country name, year (annual), and democracy index score. Since the second data is annual, and the first is not as it depends on election year, I have so far copy pasted 3 columns of data for 300 elections manually one by one, and my brain is about to explode

    I have limited experience with excel, used Vlookup function before with simpler issues, not sure if I can use it here. How can I have excel do the work for me? I would like it to transfer democracy index score to first spreadsheet if the columns for country name and year are identical.

    Thanks for any replies!

    edit: can supply the file if necessary.
    Last edited by Habermas; 12-17-2011 at 11:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1