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
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Extract Values from Several Columns [VLOOKUP Quick Tip]||How to write 2 Way Lookup Formulas in Excel? »|