Thread: get value form columns
View Single Post
 
Old 06-06-2018, 04:51 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
IN C1, try: =MAX(A1:A5)


Then in D1, try: =INDEX(B1:B5,MATCH(C1,A1:A5,0))
Reply With Quote