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

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
 
S

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)
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Ranges with Gaps - Finding Corresponding Maximum 0
sort a column without losing the corresponding value in next col 2
Figuring out a lengthy formula. Probably quite simple... 3
Summing values in a column if the date in another is of a certain month 3
display last value in a column 2
Make first imported CSV row into column names ? 3
copy row to different tab 7
Returning Column Header based on Row and Value 3

Top