Cross Sheet JOIN/COLLECT/INDEX/MATCH conundrum.

Jim B

Hi all, going a bit crazy trying multiple variants on these formulae to get my desired outcome. Hoping someone can put me out of my misery.

In my source sheet I have columns and rows like this:

In my destination sheet I want to pull in a list of Projects from the source sheet that are Flagged "Yes". Like so.

It seems so simple, and yet, I cannot compile a working formula.

Can anyone assist?

Thank you.

Jim

Brucey

Hey Jim,

I had a similar issue recently but I found a few workarounds.

1. You can create a report and use a filter to show only projects that are flagged as 'Yes'
2. You can create an automation that determines any projects flagged as 'Yes' get copied/ moved over to another sheet.

Is that helpful?

Jim B

Hi Brucey,

Thanks so much for your response. I'll use the automation option in this instance. I just didn't want to be defeated by what seemed like such a straightforward formula.

Thank you.

Jim