match the cell and bring the amount

R

Ranjith Kurian

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top