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.
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.
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks