# 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
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
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
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
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
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
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