Excel VLOOKUP, HLOOKUP and MATCH INDEX
VLookup, HLookup and MATCH-INDEX are the most common terms when somebody talk about Excel.
Not only that, but it is among favorite questions during interviews where excel skillset is required.
In this video you'll learn everything about VLOOKUP, HLOOKUP and MATCH INDEX Lookup.
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
HLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Match Index is another important lookup technique which overcomes the drawbacks of Vlookup and Hlookup.