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

[Ingrid]

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

 

[squenson via OfficeKB.com]

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)

 

[daddylonglegs]

You can use

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

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)