create a unique list based on a specific phrase

Hi again,

I am trying to create a list that has unique values (again).

I need specific information returned in a created list that is unique to the Value and based on the Description field.

There can be duplicate Values each with varying Descriptions. When ALL the same Values have the Description equal to "Yes, it will work.", the returned list should return "Yes, it will work." Otherwise, i dont care what goes into the cell as long as it isnt "Yes, it will work."


I have some fake data (on the left), with the created list (on the right) with what it should contain.

Thanks for all the help!
Joanne

Formula in D3

=VLOOKUP(B3,$F$3:$G$14,2,0)

Please see attached file

Think your intents to isolate the problematic Values items could be served like this
With your unique Values data running in F3 down,
Put in say, E3:
=IF(SUMPRODUCT(($B$3:$B$38=F3)*(TRIM($D$3:$D$38)<>"Yes, it will work"))>0,"x","")
Copy down to flag all problematic Values items (as x)
The TRIM is optional, but makes it more robust since we are checking text
-------------------------------------------------
Success? Celebrate it, click the little star at the bottom left of my response

Is it something like this?

See Table 2

You're welcome and thank you for your feedback. Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).