If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two lists or columns of data.

I’ll also share with you the key things you need to avoid to ensure your VLOOKUP works correctly.

—Read the full blog post and DOWNLOAD the files Sharyn’s using here: https://excelatwork.co.nz/excel-using-vertical-lookups-to-reconcile-accounts

Become an Excel at Work Insider (100% free) and be FIRST TO KNOW about new videos, blogs and special offers: https://www.excelatwork.co.nz/2017/06/20/excel-using-vertical-lookups-to-reconcile-accounts/

VERSION FRIENDLY
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365.
Sharyn’s using the desktop version of Excel for Office 365 as part of the Office 365 Business Premium subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelIntermediate #ExcelatWork #ExcelVLOOKUP

Please take the opportunity to connect and share this video with your friends and family if you find it useful.