Excel - Complex Lookups

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

The focus of this session is on using advanced LOOKUP functions in a variety of different ways to quickly find answers within a dataset. The course will also introduce a variety of useful functions regarding formula and error management. Lookup functions are one of the most frequently used advanced features in Excel, and this course will expand your knowledge of their power.

 

Upcoming Class Dates and Times

Aug 26, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 20, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 11, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 02, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 28, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Dec 20, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • Compare two lists with VLOOKUP and use IFNA and IFERROR to refine displayed results from a VLOOKUP.
  • Combine VLOOKUP and CONCAT to locate values based on multiple columns and use wildcards with VLOOKUP to retrieve information based on a partial match.
  • Create a combined index and match formula.
  • Use the offset function with lookup functions.
  • Return a formula as a text string from a given reference.
  • Determine if specified cells contain formulas with the ISFORMULA function.