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

Thread: [Solved] Index Results Help

View Single Post

Old

01-04-2019, 10:08 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

It is in column 3, not 2 in your INDEX-range, so:

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

You can shorten the formula by about 50% by using IFERROR instead of IF(ISERROR(...

Reply With Quote