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.