Matching two column withing two different she [Closed]

Manoj - Jan 8, 2012 at 10:59 PM - Latest reply: TrowaD 2396 Posts Sunday September 12, 2010Registration dateContributorStatus July 19, 2018 Last seen
- Jan 17, 2012 at 10:12 AM
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


See more 

1 reply

TrowaD 2396 Posts Sunday September 12, 2010Registration dateContributorStatus July 19, 2018 Last seen - Jan 17, 2012 at 10:12 AM
0
Thank you
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