Advanced Vlookup Functions


  • Mechanism and application of Exact Match

  • Mechanism and application of Approximate Match

  • Find one result that meets Multiple-criterias

  • Find one result that ‘partially’ meets the criteria

  • Find multiple results that meet required criteria(s)

  • Use Vlookup to execute searching ‘Leftwards’

  • Learn and apply Lookup

  • Summarize why Vlookup fails sometimes

  • Create synergy with IFERROR statement