Thread: [Solved] Index Results Help
View Single Post
 
Old 01-04-2019, 11:08 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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),"")
Reply With Quote