fbpx

Using Lookup Formulas with Excel Tables [Video]

Share

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
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

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher
5/5

– Jason

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

6 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 😀

  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?

  4. Q.fg says:

    Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.

Leave a Reply