Celebrate 'The VLOOKUP Book' birthday with us. Last day to get 50% discount on the e-book (31 October only).

Click here for details

Using Lookup Formulas with Excel Tables [Video]

Posted on November 9th, 2010 in Learn Excel - 5 comments

This article is part of our VLOOKUP Week. Read more.

Excel Tables, a newly introduced feature in Excel 2007 is a very powerful way to manage & work with tabular data. I really like tables feature and use it quite often. If you are new to tables, read up Introduction to Excel Tables.

In this short video tutorial I explain how to combine VLOOKUP, INDEX, MATCH formulas with Excel Tables.

[Watch the video on Youtube]

Sample File

Download Example File – Using Lookup Formulas with Excel Tables

More Resources

VLOOKUP Week @ Chandoo.org - Learn tips on lookup formulas in Excel

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

5 Responses to “Using Lookup Formulas with Excel Tables [Video]”

  1. Damian says:

    H1 !
    this is my very first comment.
    Can you use same technique with Excel 2003 lists ?
    thanks :D

  2. Tom says:

    Thanks, Chandoo! I like seeing the sneak peak of what’s to come on Friday too :)

  3. Chandoo says:

    @Damian.. Welcome to chandoo.org. Thanks for the comments.

    Yes, you can use the same with Excel 2003 lists too.

    @Tom.. You have seen future and its awesome.. isnt it?

Leave a Reply