Archives for: February 2015, 13

VLOOKUP 2nd Version (Advanced)

Formulas, Tables, Arrays
Hi there, In this video, you will be learning: 1. How to insert a database to vlookup? 2. How to make a normal range to a dynamic range? 3. About Table and its Features? 4. How to use Dynamic colu_index num in VLOOKUP? 5. Importance of ROW() and COLUMN() in VLOOKUP? 6. How to embed source table in VLOOKUP? 7. What is MATCH function in Excel? 8. How to Make Dynamic Usage of Colu_Index Num? 9. How to Use MATCH function in VLOOKUP? if you have any doubts, please leave a comment in the below comments section. more »
Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Skin Factory.