Vlookup Hacks: Hack #3 Exact Match

In this post, the 3rd in the VLOOKUP Hacks series, we’ll dig even deeper into the 4th argument. We’ll see how we can leverage it to help with our reconciliations and other list comparisons. Let’s pretend for a moment that we need to compare two lists. We’d like to find out which items on one list appear on the other list. This type of thing is often referred to as a list comparison. Accountants often refer to this task as a reconciliation. In this video, we'll use VLOOKUP to perform out bank rec. Written tutorial and sample file: www.excel-university.com/vlookup-hack-3-exact-matc… Subscribe to blog and view all posts: www.excel-university.com/blog/

• #education
• #excel_university
• #jeff_lenning