How to use lookup functions

The LOOKUP function returns a value either from a one-row or one-column range or from an array

  1. Excel Lookup Picture Approximate or Exact match

    This video is a part of VLookup Week: 1. See how to use a formula with INDEX and MATCH functions and Defined names to do Approximate or E...

  2. Match & Sorting To Reduce Exact Match Calculation Time

    Learn about Excel lookup functions Approximate and Exact Match: 1. How Exact and Approximate Match work 2. Binary search when using Appro...

  3. Index and Match functions

    There are about 30 example in this long video. It helps with understanding how to use the index and match. Its a great step by step way o...

  4. Beginner to Advanced Excel Tutorial

    This video shows howExcel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if y...

  5. Comprehensive Guide to VLOOKUP & Other Lookup Formulas

    What is VLOOKUP Formula & how to use it? I often tell my excel school students that learning VLOOKUP formulas will change your basic ...

  6. Duplicate Lookup Values

    See what to do when there are Duplicate lookup values and you need to look and return all of the items or records associated with the dup...

  7. LOOKUP function Beginner to Advanced (Video 2)

    Learn about Excel LOOKUP function: 1. Approximate Match only ( 00:40 min) 2. Table taller or equal to width, does vertical lookup ( 2:18 ...

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy