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

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
Comparing 3 Columns and Returning a Result 2
Excel Help to copy information from one row at a time to another sheet 1
Summing values in a column if the date in another is of a certain month 3
copy row to different tab 7
Figuring out a lengthy formula. Probably quite simple... 3
sort a column without losing the corresponding value in next col 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top