I have a data set where a participant entered their then and then the members of their group. I have an IF Array statement to pull the names of participants based on who said a certain name as their group member.
NOW, I need an array to display the entire row of data associated with these names. The problem I am having is this array is dependent on the original IF Array statement.
Is there a way to nest arrays or another way to display an entire row of data?
My IF Array: {=IF(C3=D3:I26,C3:C26,FALSE)}
My INDEX Array attempt: {=INDEX(K3:AH26,IF(C3=D3:I26,C3:C26,0),0)}
Bookmarks