Vlookup,hlookup techniques /formula

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

HLOOKUP works just like VLOOKUP, but horizontally rather than vertically. So everything I say about VLOOKUP also applies to HLOOKUP.

Excel’s Best Lookup Method: INDEX-MATCH :

The most powerful and flexible way to look up data in Excel is the INDEX-MATCH method. It relies on two Excel functions:

=INDEX(reference, row_num, column_num)

    reference—a range of cells
    row_num—the row in reference from which to return data.
    column_num—the column in reference from which to return data.

If reference is one row or column, the INDEX function can use this syntax:=INDEX(reference, cell_num)

=MATCH(lookup_value, lookup_array, match_type)

    lookup_value—The value to match in lookup_array.
    lookup_array—A range of cells with data.
    match_type—Specifies how Excel matches the lookup_value with values in the lookup_array. For exact matches, always use 0 for this argument.

Zero Addiction Powder