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