Hello,
I have the following index/match lookup only in visible cell working properly, however....
=IFERROR(INDEX($F$2:$F$500,SMALL(IF(((SUBTOTAL(3,OFFSET($G$2:$G$500,ROW($G$2:$G$500)-MIN(ROW($G$2:$G$500)),,1))>0)*($K$517=$G$2:$G$500)),ROW($G$2:$G$500)-MIN(ROW($G$2:$G$500))+1),1)),"")
Column F is what I want returning, Column G has the criteria value in them. K517 is the lookup value.
Now from Column F there are more then 1 results to be return. I want to use the "&" and string all the return results in a single cell. How should I approach?
To clarify, Say I want to look up "Adam" (K517) it returned the first value "red" from Column F. However, there are also "yellow and Blue" that matches "Adam". So I want in a cell to display (Red, yellow, blue) based on the filtered cell. Hope that make sense, thank you in advance.
James,