+ Reply to Thread
Results 1 to 2 of 2

Compare 2sheets and insert data

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    176

    Compare 2sheets and insert data

    i am attached sheet1 and sheet2 here common is borrower id. here i want to insert loan amount in sheet2 from sheet1 if borrower id was match for full columns if not in sheet 1 then it will be 0 in sheet 2 loan amount column.
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,750

    Re: Compare 2sheets and insert data

    Try

    F2=SUMIFS(Sheet1!E:E,Sheet1!B:B,Sheet2!B2)

    copy down
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ Reply to Thread

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