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. video Completed

    Excel Lookup Picture Approximate or Exact match

    &nbsp;This video is a part of VLookup Week: &nbsp;1. See how to use a formula with INDEX and MATCH functions and Defined names to do Approximate or Exact match lookup. 2. See formula inserted into picture for Excel 2010 and 2003.&nbsp;<br><br>Learn three easy tasks in a tutorial that shows you exactly how to use it!&nbsp;

    Edit Remove Move
  2. video Completed

    Match & Sorting To Reduce Exact Match Calculation Time

    &nbsp;Learn about Excel lookup functions Approximate and Exact Match: 1. How Exact and Approximate Match work 2. Binary search when using Approximate Match 3. See how to use 2 LOOKUP functions using Approximate Match to simulate Exact Match in order to reduce calculation time because of binary search 4.

    Edit Remove Move
  3. video Completed

    Index and Match functions

    &nbsp;There are &nbsp;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 of learning.

    Edit Remove Move
  4. video Completed

    Beginner to Advanced Excel Tutorial

    This video shows how&nbsp;Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP. In this video learn everything you need to know about VLOOKUP in 1 video.

    Edit Remove Move
  5. article Completed

    Comprehensive Guide to VLOOKUP & Other Lookup Formulas

    &nbsp;What is VLOOKUP Formula &amp; how to use it? I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data. Great text tutorial to teach you the basics.

    Edit Remove Move
  6. article Completed

    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 duplicate lookup values. See Formula, Filter and Advanced Filter Methods. Videos 358, 359, 360 teach all the concepts of how array formulas work for this sort of situation. Great tutorials through this page.

    Edit Remove Move
  7. video Completed

    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 min) 3. Table wider than tall, does horizontal lookup ( 3:48 min)&nbsp;<br><br>You learn a handful of techniques to help you better understand the lookup function.&nbsp;

    Edit Remove Move

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