Over the years this popular function has been the subject of the most questions to me from CPA’s from around the world. So I thought I would dedicate a whole webinar to how and why to use it. I have also included techniques to get around the limitations of the function. Most content applies to all Excel versions.

In this session I will cover

• the Exact match VLOOKUP – when to use it

• the Approximate match VLOOKUP – when to use it

• tips and shortcuts on using VLOOKUP

• common problems with VLOOKUP and their solutions

• why Format is Table is so important

• handling errors

• handling multiple tables

• removing the left column limitation

• two column lookups (non array solution)

• using the Relationship option to avoid VLOOKUPs (Excel 2013 and later only)

As always, I will share a few general tips along the way.

Level: Intermediate
Duration: 1.5 hours
Price: AU$25