Lookup Tools

The index function in excel returns a value from the table(array). We obtain the value from the intersection of the row number and the column number defined in the formula. The row_num and column_num are according to the array that we choose. Formula: =INDEX(array, row_num, [column_num]) Excel Match Function Definition with Formula: Excel Match function … Read more

VLOOKUP in excel means “Vertical LOOKUP”. It means that it helps to look up a value vertically, i.e., in a different column but the same row. In the case of repeated values, the first matched value will return. Formula: VLOOKUP(lookup_value; table_array; col_index_num; [range_lookup]) Lookup Value: It is the given value and for this, we have … Read more

HLOOKUP in excel means “Horizontal LOOKUP“. It means that it helps to look up a value horizontally, i.e., in a different row but in the same column. In the case of repeated values, the first matched value will return. Formula: HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Xlookup in Excel Definition with Formula: Xlookup in excel helps look … Read more