![]() |
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