Using Lookup Formulas with Excel Tables [Video]

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

• What is VLOOKUP Formula and how to use it?
• Using INDEX + MATCH Combination to fetch values from left
• What is Excel Tables feature and how to use it