How to Use VLookup for Bank Reconciliation - Excel (book balancing)

*NOTE*: When you're highlighting the table array...make sure the unique key is in the first column of data that you're highlighting or you'll get an error.

[carolm]

I wish you added the worksheets that you used in your vid to the description so we can download it to practice

[michaelporter]

Only good for checks for wires and ACH you can do vlookup using the transaction date. This helps only if you are recording your wires and ACH transactions on the same day as they hit your account

[RR-etzp]

This ain’t to look for double entries though

[neptuneuwu]

Thank you for this. Quick and easy to understand explanation!

[joicecarinat.manuel]

Super helpful ! Thank you very much 👏🏽👏🏽

[dicksontautarimaru]

Can you used vlookup in trade debtors reconciliation?

[terencezhan]

That's really helpful, thank you!

[funmigbokoyi]

This was a bit helpful, next time please, kindly zoom in so we can clearly see the formulars, thank you.

[alyssaburgos]

Hi, what if there's no transaction id? Only the date, description, and amount. Would this still be possible?

[FirozAlam-doch]

Hi, Andrew if there is no currency sign so in that case what we need to put in key 3 Or 4 ?

[niyitegekaedson]

Helloo Sir What if you don't have Transaction ID or Reference?
Thank you

[sadikshyahumagain]

I am just getting error in value
What went wrong?

[小孩萝卜]

Can i ask why need to key "3 " in vlookup formula?

[philipshergold]

What if you don't have a unique transaction number in the books or bank and want to merely go by the date?

[paulhan]

03:10 - no need to drag, just double click twice man.

[ahmadhasnain]

This video is to much zoomed out for a youtube video.

[joicecarinat.manuel]

Super helpful ! Thank you very much 👏🏽👏🏽