web developer
78 Points
Joined November 2015
=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