Mac numbers get value of adjacent cell

Question

Level 1

5 points

Mac numbers get value of adjacent cell

I'm using formulas to display results in a separate table. The table I'm calculating from has two columns, the left being a label and the right being a value. Like so:

Column 1	Column 2
Label X	34%
Label Y	12%
Label Z	44%

In my results table, I can use Max to identify the largest value (e.g. 44%), but what I want to display is the label from the adjacent column (e.g. Label Z). Is there a way to use Max to identify the row, and then point to the value in a cell one column to the left? If not, is there a way I can include the label and value in the same cell and still use Max or some alternative to order them?

iMac, iOS 10.3.3

Posted on Aug 3, 2017 9:13 AM

Reply

Answer 1

SGIII

Level 8

37,550 points

Aug 3, 2017 9:43 AM in response to maclingo

You can do something like this:

=INDEX(Table 1::A,MATCH(MAX(Table 1::B),Table 1::B,0))

The MATCH finds the row number of the largest value (the MAX) in column B of Table 1. It feeds that row number to INDEX, which retrieves the value for that row number from column A.

SG

Reply

Answer 2

maclingo Author

Level 1

5 points

Aug 3, 2017 9:43 AM in response to maclingo

Awesome! Thanks.

Reply