get value form columns

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

06-06-2018, 04:51 AM

NBVC

Windows 10 get value form columns

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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

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

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 02:53 AM.