Hi,
Can anyone tell me that whwther we can reconcile the bank with the help of VLOOKUP function in excel??? If Yes, then how?Please explain........
Menu
Bank Reconcilation
Replies (4)
Hi Jyoti
Yes it is possible.
Since cheque no being common in both bank statement & bank, we can pick up the ch.no with vlookup formula.
but ensure that in both the statement it should be typical.
Regds
Balaji S.
hello Sir,
Can you explain how to use VLOOKUP function ?I don't know its use
Thanks in advance..
Regards,
Jyoti
Hi jyoti
First u have to sort both bank book & bank statement cheque numberwise than u can use the vlookup formula for brs.
if u have problem u mail me some samples to balajisarangarajan @ hotmail.com
i ll do it & send it to u
regds
Balaji
The easiest way we use to do in excel is we will download the bank book and sort amount wise lower level to upper level. Then by going thro' the bank statment we will finish it very fastly. U can also try.
Related Topics
CAclubindia
