If you found this webinar helpful InvestinU offers a range of training supports for Microsoft 365 which can be found here.

You can check out our FacebookInstagram, or Linkedin pages for more updates and to get in touch today!

Webinars – LOOKUPs

The Alternative to the LOOKUP – Index and Match

Apart from VLOOKUP, INDEX and MATCH are the most widely used tools in Excel for performing lookups. The INDEX and MATCH combo is potent and flexible, and you’ll see it used in all kinds of formulas, from basic to very advanced.

However, while VLOOKUP allows you to perform lookups with a single function, INDEX and MATCH requires two functions, one nested inside another. Many users find this confusing, because they aren’t used to combining functions in Excel, so they avoid INDEX and MATCH.

This Webinar explains in simple terms how to use INDEX and MATCH together to perform lookups. It takes a step-by-step approach, first explaining INDEX, then MATCH, then showing you how to combine the two functions together to create a dynamic two-way lookup.

In this 60 Minute fast-paced learning session, you’ll learn:

  • Lookup vs Index and Match
  • Match Function
  • Index Function
  • Index and Match together
  • Creating a 2-way lookup

 

Duration:
60 Mins

Like this? Wanna see more webinars?

We have lots of different webinars on offer. To read more about them, click the button below.

Get in Touch

Would you like to discuss your companies requirements with us?

If so, please get in touch and we can organise a face to face zoom meeting at a time that suits you.

Call Us

International: +353 85 133 5649
Ireland: (085) 133 5649

   About InvestinU

   In the Media

   Testimonials

  Training

   Bespoke Online Webinars

   Expert Advisory Sessions

   Microsoft 365 Support

   Customised Training

   One-to-one Consultancy

   Bite-Size Learning

   Design

   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design

   Web

   E-commerce Websites

   Brochure Websites

   SEO

   Social Media Management

   Content Creation (Blog)

    Development

   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Invest365 Microsoft Webinars

   Invest365 Microsoft Support

   Expert Advisory Sessions

   Invest365 Microsoft Ultimate