Excel University Volume 2 - Featuring Excel 2016 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals by Jeff Lenning

Author:Jeff Lenning [Lenning, Jeff]
Language: eng
Format: azw3
Published: 2017-04-03T04:00:00+00:00

When this formula is filled down, Excel returns an integer value when the check appears in the bank download and the #N/A error when the check does not appear. This outcome makes it fast and easy to see which checks haven’t yet cleared the bank.

However, we prefer to return the amount of the check rather than its relative position. Let’s try the VLOOKUP function next.

EXERCISE 2—VLOOKUP

In this exercise, we’ll use the VLOOKUP function to determine if a check cleared the bank.

PRACTICE

To work along, please refer to the Exercise 2 worksheet.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.