Trying to return a number of different text values

[ExcelLevel0]

Hi,

I am looking to create a function that will search through a column, if the condition is met I am looking for it to return a text value from another column.
I setup the formula =if(c2="carcass-head on",T(L2),"") that function performs the task I am looking for and provides the text from the L cell. Now what I am trying to do is search the entire C column whenever a certain weight type is present, I was to get the point of sale information from the corresponding L cell, without duplicates.

Does anyone know if this is possible?

[etaf]

can you post a sample sheet with expected results
Copying the formula down would test the column
BUT not 100% sure what you are after
How do you define duplicates in your requirement

[ExcelLevel0]

Hi eta,

I posted a sample sheet. So I am looking to create a list of all the points of sale where there are sales with the weight type carcass-head on, based on the sample sheet I would want the Conestoga Flemming, and Brock to be returned once.

[etaf]

you could use a pivot table , would that work for you
There are some array formulas that would also work, but a pivot table would work quicker and on large data file
see attached