get value form columns

		Microsoft Office Forums > Microsoft Excel > Excel
get value form columns

06-06-2018, 06:13 AM

Shashi Kant Shashi Kant is offline

Windows 7 32bit get value form columns

Office 2016

Novice

Join Date: May 2018

Posts: 16

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 PM.