+ Reply to Thread
Results 1 to 4 of 4

Panel data: If cells match in two sheets then copy to another sheet

  1. #1
    Registered User
    Join Date
    06-09-2020
    Location
    Berlin, Germany
    MS-Off Ver
    Office 365
    Posts
    2

    Question Panel data: If cells match in two sheets then copy to another sheet

    Hi all,

    I am despreately looking for a solution to my issue in order to complete a panel data set. I tried already vlookup, index,match but could not really find a work around. I hope you can help me, preferebly with a formula instead of VBA :)


    My issue:

    I would like to fill C2 from the sheet "Panel dataset" with B2 form the sheet "Debt to GDP". Since my dataset is much much bigger than the example I am looking for a forumla that fills C2 if a cell in "Debt to GDP" matches with the country (Albania) and the year (2001) in both sheets.

    Hope you can help me out.

    Best wishes and many thanks!

    ps. I work in Office 365
    Attached Images Attached Images
    Last edited by Krotos; 06-11-2020 at 06:50 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,394

    Re: Panel data: If cells match in two sheets then copy to another sheet

    Welcome to th forum.

    You cannot MOVE data with a formula, but reading what you have said, I'm not sure that's what you are trying to do.

    There are instructions at the top of the page explaining how to attach your sample workbook. Make sure you include some manually mocked-up results.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Panel data: If cells match in two sheets then copy to another sheet

    You can probably use INDEX/MATCH/MATCH for this, but a sample file will get you more accurate suggestions.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    06-09-2020
    Location
    Berlin, Germany
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Panel data: If cells match in two sheets then copy to another sheet

    Thanks for your quick response. Just solved it with Index Match Match


    Many thanks!
    Last edited by Krotos; 06-11-2020 at 06:49 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 09-16-2015, 01:18 PM
  2. Replies: 0
    Last Post: 05-27-2015, 10:23 AM
  3. match data 2 sheets. if match, then copy data from one sheet to another
    By flunzy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-09-2013, 06:38 AM
  4. Match cells on two sheets, copy columns to sheet 3
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2013, 09:42 PM
  5. Replies: 0
    Last Post: 10-25-2012, 03:38 PM
  6. Macro to Compare two sheets, if match then copy two cells from one sheet to the other
    By ali.whitaker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 02:13 PM
  7. If cells match from two sheets, copy entire row to new sheet function
    By Ckapp22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2012, 05:36 AM

Tags for this Thread

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