get value form columns

abrarrazakhan · #1 06-06-2018, 01:50 AM

suppose we have values in A1=2,A2=5,A3=7,A4=6,A5=4 and in B1=f,B2=s,B3=z,B4=s,B5=t.how to get maximum value from column A(which is 7) and how to get value from column B which is in front of maximum value from column A(which is z)

NBVC · #2 06-06-2018, 04:51 AM

IN C1, try: =MAX(A1:A5)

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

Shashi Kant · #3 06-06-2018, 06:13 AM

Dear Friend,

Kindly use below formula

=INDEX($A$1:$B$5,MATCH(MAX($A$1:$A$5),$A$1:$A$5,0) ,2)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert 8 columns into 3 columns	BendixB	Excel Programming	2	08-08-2018 12:39 PM
Need to change table to text so that both columns merge to form 1 line	jrasicmark	Word	3	02-24-2015 07:28 AM
designing a custom outlook form - this form is for only sending mails nt collect data	balamuralibm	Outlook	0	05-21-2014 08:08 AM
Form Fields - Create blank form text field with if statement?	LAssist2011	Word	5	12-14-2011 03:02 PM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM