Join us for an online event!

Advanced Microsoft Excel for Professionals: Complex LOOKUPS

Wednesday, August 3rd, 2022

12:00 - 12:20 PM CST 

Register now

What will you learn?

Excel has multiple LOOKUP and Reference functions that let you find matching values. Deciding when and where to use said functions can be difficult. Using VLOOKUP can help when you need to view things in a table or a range by row in Microsoft Excel. Register today to learn how to utilize the LOOKUP functions to look through large amounts of data for your organization.

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.