I have the following index/match lookup only in visible cell working properly, however....
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.