Looking up corresponding entry in table?

Z

Zerex71

I am wondering if I can combine the MIN()/MAX() and *LOOKUP() functions
to perform the following task. Suppose I have a table of data (2D) and
want to use the MIN()/MAX() functions to pick out the min and max
values in the Y-column respectively. Furthermore, suppose I want to
pick out which X-value produced those values. Can this be done?

Mike
 
B

Bernard Liengme

In A1:A6 (my x-values) I have some numbers; likewise in B1:B6 (my y-values)
The lowest B value is 3 and it occurs in B4, next to this in A4 is the
number 13
The formula =MIN(B1:B6) returns the value 3 (lowest value in the range)
The formula =MATCH(MIN(B1:B6),B1:B6,0) returns the value 4 since the 3 value
was in the fourth cell of the range
Finally =INDEX(A1:A6,MATCH(MIN(B1:B6),B1:B6,0)), locates the forth entry in
the x-range and returns its value - in my case 13.
best wishes
 
Z

Zerex71

Thank you very much!

Bernard said:
In A1:A6 (my x-values) I have some numbers; likewise in B1:B6 (my y-values)
The lowest B value is 3 and it occurs in B4, next to this in A4 is the
number 13
The formula =MIN(B1:B6) returns the value 3 (lowest value in the range)
The formula =MATCH(MIN(B1:B6),B1:B6,0) returns the value 4 since the 3 value
was in the fourth cell of the range
Finally =INDEX(A1:A6,MATCH(MIN(B1:B6),B1:B6,0)), locates the forth entry in
the x-range and returns its value - in my case 13.
best wishes
Click to expand...
 
Top