
Why Vlookup when there is Index?
Vlookup: The syntax for Vlookup is: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Index: The Syntax for Index is: INDEX( array, row_number, [column_number] ) Match: The Syntax for Match is: MATCH( value, array, [match_type] ) Problem:… Read more »