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.
- 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
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
More awesome tips for you:
Leave a Reply
|Extract Values from Several Columns [VLOOKUP Quick Tip]||How to write 2 Way Lookup Formulas in Excel?|