Article updated on June 21, 2012

Problem: Find the most expensive product.
In a table, find the largest value and return the adjacent value.

Formula in D6:

=VLOOKUP(MAX(A2:A11), A2:B11, 2, FALSE)


MAX(number1, [number2], ...)
Returns the largest value in a set of values. Ignores logical values and text.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specifiy. By default the table must be sorted in ascending order.