Thread: Showing the contents of a cell based on another cell
View Single Post
  #3   Report Post  
DOR
 
Posts: n/a
Default Showing the contents of a cell based on another cell
=INDEX(A2:A5,MATCH(B10,B2:B5,0)) or

=INDEX(A2:A5,MATCH(MAX(B2:B5),B2:B5,0)) does it in one formula

HTH

Reply With QuoteReply With Quote