Excel: Find largest value in a table and return adjacent cell value
Filed in Excel on Aug.06, 2007. Email This article to a Friend
Problem: Find the most expensive product.
In a table, find the largest value and return the adjacent value.
Solution:=VLOOKUP(MAX(A:A);A:B;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.
Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.Don´t forget to add my