Originally Posted by
Glenn Kennedy
Maybe this to return the header:
=IFERROR(INDEX(TEST!$C$1:$H$1,AGGREGATE(15,6,COLUMN(TEST!$C$1:$H$1)-COLUMN(TEST!$C$1)+1/(INDEX(TEST!$C$4:$H$13,MATCH($A5,TEST!$A$4:$A$13,0),)>0),COLUMNS($B4:B4))),"")
and this to return the value:
=IFERROR(INDEX(INDEX(TEST!$C$4:$H$13,MATCH($A5,TEST!$A$4:$A$13,0),),AGGREGATE(15,6,COLUMN(TEST!$C$1:$H$1)-COLUMN(TEST!$C$1)+1/(INDEX(TEST!$C$4:$H$13,MATCH($A5,TEST!$A$4:$A$13,0),)>0),COLUMNS($B5:B5))),"")
both copied across. But... it's a guess as you did not shiow us your expected answers... as requested.
Bookmarks