ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   match the cell and bring the amount (https://www.excelbanter.com/excel-programming/432935-match-cell-bring-amount.html)

Ranjith Kurian[_2_]

match the cell and bring the amount
 
I have two sheets one is master and the other one is current example is as
shown below:

my master sheet contain all the information, i just want to cross check the
master sheet with current sheet whether the amounts are taken correctly.

Master sheet:
Name AMT
A 10
A 20
A 30
B 40
B 50
C 60
C 60
C 70

Current sheet
Name AMT ANSWER
B 40 40
B 60 50
C 60 60
C 60 60

ANSWER column is the result picked from master sheet, here if u notice the
name B has one different amount and in name C the amount has taken correctly
but it missed out one column with amount 70.




All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com