Hi Folks,
I have this formula that finds one column of matches but I need a second column to also be returned. I need help in fixing this formula to allow the second column of matched info to be listed in column D if possible. Thanks
Formula: =IF(ISERROR(INDEX('Analysis 1'!$A$1:$F$9211,SMALL(IF('Analysis 1'!$A$1:$A$9211=$C$1,ROW('Analysis 1'!$A$1:$A$9211)),ROW(1:1)),2)),"",INDEX('Analysis 1'!$A$1:$F$9211,SMALL(IF('Analysis 1'!$A$1:$A$9211=$C$1,ROW('Analysis 1'!$A$1:$A$9211)),ROW(1:1)),2))
Link to screen capture of results I currently get
https://drive.google.com/open?id=1o7yz2dwdWavFfL_TIqbTpo7itjoSUlCi
Thank you
I have this formula that finds one column of matches but I need a second column to also be returned. I need help in fixing this formula to allow the second column of matched info to be listed in column D if possible. Thanks
Formula: =IF(ISERROR(INDEX('Analysis 1'!$A$1:$F$9211,SMALL(IF('Analysis 1'!$A$1:$A$9211=$C$1,ROW('Analysis 1'!$A$1:$A$9211)),ROW(1:1)),2)),"",INDEX('Analysis 1'!$A$1:$F$9211,SMALL(IF('Analysis 1'!$A$1:$A$9211=$C$1,ROW('Analysis 1'!$A$1:$A$9211)),ROW(1:1)),2))
Link to screen capture of results I currently get
https://drive.google.com/open?id=1o7yz2dwdWavFfL_TIqbTpo7itjoSUlCi
Thank you
