finding a corresponding value in the same row in a different colou
 

Hi

I am trying to find a code that will allow me to find a maximum value in a
column (say column B) and then finds the corresponding value in the same row
in column A.

Thanks I am quite desprite so any advise would be fantastic

finding a corresponding value in the same row in a different colou
 

You can use the function MATCH to retrieve the row on which your value is,
then the function INDEX to retrieve the value in column A. Example: which
value is in column A in range A1:B10, where 5 is in colun B?
=INDEX(A1:B10,MATCH(5,B1:B10,0),1)

Ingrid wrote:
Hi

I am trying to find a code that will allow me to find a maximum value in a
column (say column B) and then finds the corresponding value in the same row
in column A.

Thanks I am quite desprite so any advise would be fantastic

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200707/1

finding a corresponding value in the same row in a different c
 

You can use

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

"squenson via OfficeKB.com" wrote:

You can use the function MATCH to retrieve the row on which your value is,
then the function INDEX to retrieve the value in column A. Example: which
value is in column A in range A1:B10, where 5 is in colun B?
=INDEX(A1:B10,MATCH(5,B1:B10,0),1)

Ingrid wrote:
Hi

I am trying to find a code that will allow me to find a maximum value in a
column (say column B) and then finds the corresponding value in the same row
in column A.

Thanks I am quite desprite so any advise would be fantastic

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200707/1