The lookup values must appear in thefirstrow of the table, moving horizontally to the right.
HLOOKUP supports approximate and exact matching, andwildcards(* ?)
for finding partial matches.
HLOOKUP searches for a value in thefirst rowof a table.
When it finds a match, it retrieves a value at that column from the row given.
Use HLOOKUP when lookup values are located in the first row of a table.
Use VLOOKUP when lookup values are located in the first column of a table.
The first argument, calledlookup_value, is the value to look up.
The second argument,table_array, is a range that contains the lookup table.
The third argument,row_index_numis the row number in the table from which to retrieve a value.
The fourth and final argument,range_lookup, controls matching.
Use TRUE or 1 for an approximate match and FALSE or 0 for an exact match.
The lookup table is in H4:J6, which is thenamed range"table".
Note this is an approximate match scenario.
For each amount in C5:C13, the goal is to find thebestmatch, not anexactmatch.
Notice the last argument,range_lookupis set to FALSE to require an exact match.
LOOKUP’s default behavior makes it useful for solving certain problems in Excel.
you’re free to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
XLOOKUP supports approximate and exact matching, wildcards (* ?)
It is a more robust and flexible successor to the MATCH function.
XMATCH supports approximate and exact matching, reverse search, and wildcards (* ?)
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
This makes FILTER a flexible way to isolate and inspect data without altering the…
