Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
Wednesday, March 26, 2025
9-11 a.m. Central
2 CPE (2 non-technical)
Course code: 24WS-2032
View pricing
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
Major subjects
-
Using lookup functions as an alternative to direct cell references
-
Understand the limitations of the VLOOKUP function
-
Discover ways to move beyond these limitations
Learning objectives
-
Recognize when and why a lookup function is better than a direct cell reference
-
Use three of Excel's many lookup functions
-
Gain comfort with the arguments of the functions presented
Who should take this program?
- Accounting professionals using Excel for Windows
Pricing
|
Standard Member Fee |
$99.00
|
 Standard Nonmember Fee |
$99.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$99.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Instructor
Jeff Lenning, CPA, CITP
Location
Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level
Basic
Format
Group Internet Based
Sponsor
NASBA ID#: 103212
Prerequisites
Prereq.
Basic knowledge of Excel for Windows
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business
days before the event start date.
Learn more
Search CPE catalog
