Report

Matching two column withing two different she [Closed]

Ask a question Manoj - Last answered on Jan 17, 2012 at 10:12 AM by TrowaD
Hello,


I have two sheet one is RIB which remittence into bank and 2nd one is bank statement


i have to match rib with bank statement every month. but problem is that there is no unique identifier in both sheet. so i use vlookup for match but when same amount occur there proble. Condition for matching the amout that is date of bank statement where amount match with RIB is equal or greater then the date of RIB amount. I attach the both file for your reference.

As u seen in rib statement Amount of Rs. 21433 is three time two time in dated 02-01-2011 and one time in 03-01-2011. but in bank statement this amount is two but one one is on 01-01-2011. 2nd is on 03-01-2011 when i try vlookup it match with both amount of rib but its not true i want exact position with the conidtion bank statement date is equal to or greater then the date of rib matched amount date.

waiting for your response



Thanks

Manoj

Phone number removed for security

India


Helpful
+0
plus moins
Hi Manoj,

Didn't find any attached document. Try a file sharing site like www.speedyshare.com and post back the link. Keep in mind that I'm using Excel 2003 and therefore need the extension to be .xls.

Please show in your file what you would like to accomplish.

Best regards,
Trowa

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!