Microsoft Office Forums - View Single Post - get value form columns

Thread: get value form columns

View Single Post

Old

06-06-2018, 06:13 AM

Shashi Kant Shashi Kant is offline

Shashi Kant is offline

Shashi Kant uses Windows 7 32bit

Windows 7 32bit Shashi Kant uses Office 2016

Shashi Kant uses Office 2016

Office 2016

Novice

Join Date: May 2018

Posts: 16

Shashi Kant is on a distinguished road

Default

Dear Friend,

Kindly use below formula

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

Reply With Quote