VLOOKUP to Return Value - Duplication Issue

elisabelville

Hello,

I am needing help with my formula - I have project plan template I am working with. My goal is to get the formula to pull up the Task Names that have a Milestone Flag in the first column.

The problem I am having, the formula works, but only for the first result (first flagged item), and duplicates the task name in each row the formula is in, instead of pulling up the remainder of the flags

Genevieve P.

Hi @elisabelville

Instead of a VLOOKUP, try a JOIN(COLLECT instead. See: Gather all matching content into one cell

=JOIN(COLLECT([Task Name]9:[Task Name]225, Milestone9:Milestone225), ", ")

Cheers,

Genevieve