# 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 &amp; 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 ...