Microsoft Office Forums - View Single Post - [Solved] Index Results Help

Thread: [Solved] Index Results Help

View Single Post

Old

01-04-2019, 11:58 AM

radicalrom radicalrom is offline

radicalrom is offline

radicalrom uses Windows 10

Windows 10 radicalrom uses Office 2016

radicalrom uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jan 2019

Posts: 9

radicalrom is on a distinguished road

Default

Quote:

Originally Posted by xor

View Post

Shortened array formula in K2:

=IFERROR(INDEX($A$1:$H$16,SMALL(IF($A$1:$A$16=$J$1 ,ROW($A$1:$A$16)),ROW(1:1)),3),"")

This is AWESOME! Thank you, Thank you and Thank you!!!!! I love the shorter version!

Reply With Quote