Thread: finding a corresponding value in the same row in a different colou
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
  
Posts: 78
Default 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

Reply With QuoteReply With Quote