I am sending u sample file in this file two sheet one is rib(Remitance into Bank) and another is Bank statment. I wish to match rib statement with bank statement. I put up vlookup formula for that. i getting problem with vlookup when same amount occuer in the rib statment. As u seen in the sheet rib there are 3 times 150 but in the bank statement only 1 times but vlookup matched the all three 150 in rib statement. i want that it matched with one by one or u can say if one time 150 in that then matched with one time and not available show for another two. Please solve my problem to provide excel addin . if possible i want to put to want date check also. date of matched amount in bank statement cannot be less then the date of rib statement.