## Find largest value in a table and return adjacent cell value

*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)

**Functions:**

**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.

This post explains how to lookup a value and return multiple values. No array formula required.

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]

I have a list of names in a row, say A1:E1, and a list of values in a corresponding row, say A4:E4. I want to find the lowest value in the A4:E4 range and return the corresponding lowest name to a cell on another worksheet. Would you know how that is done?

John,

See attached file:

John.xlsx