8 Things You Need to Know About Mastering VLOOKUPS

8 Things You Need to Know About Mastering VLOOKUPS

  1. It can only work from Left to right (aka a Left Lookup)
  2. It always finds the first match
  3. It is not case-sensitive (can be with Case Function)
  4. It has two match types (True – Approx, False – Exact)
  5. It uses approximate match by default
    • For approximate matches, data must be sorted
    • You can force VLOOKUP to do an exact match
  6. It allows wildcards for partial matching (* – Wild Card)
  7. You can use it as an alternative to a nested IF statement
  8. It can only handle a single criterion

Aug 06, 2020

Eoin Lynch

   About InvestinU

   In the Media


   Careers at InvestinU


   Bespoke Online Webinars

   Expert Advisory Sessions

   Microsoft 365 Support

   Customised Training

   One-to-one Consultancy

   Bite-Size Learning


   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design


   E-commerce Websites

   Brochure Websites


   Social Media Management

   Content Creation (Blog)


   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Invest365 Packages

   Invest365 Webinars

   Invest365 Support

   Expert Advisory Sessions

   Invest365 Ultimate