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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
You can use

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

squenson via OfficeKB.com said:
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)
Click to expand...
 
Back
Top