VLOOKUP Function

 Price: $35 incl GST

Duration: 1 hour

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 only)

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

Date: May 24, 2018
Time: 1:00 PM AEDST
Event: Webinar - VLOOKUP Function
Topic: VLOOKUP Function
Public: Public
Registration: Click here to register.