Join Collect Function not working

Hammermill21

Hello!

I have this formula and it doesn't seem to work:

=JOIN(COLLECT([Capacity-Space Planning]2:[Capacity-Space Planning]245, [Property Name]2:[Property Name]245, [Property Name]@row, Space2:Space245, Space@row))

I'm not sure what I'm doing wring, it's not bring back anything.

Help!

Paul Newcome

Which range are you trying to join the data from?

Hammermill21

Hi Paul,

So I've moved the data to another sheet to see if that makes this easier.

=JOIN(COLLECT({DATA || Gables Alternative Classroom Range 4}, {DATA || Gables Alternative Classroom Range 2}, [Property Name]@row, {DATA || Gables Alternative Classroom Range 3}, Space@row))

So I have the [Property Name]@row with is Aresty Building & [Space]@row which is 531

That need to both match and bring me back the Capacity-Space Planning number:

Does that make sense?

Paul Newcome

It doesn't look like the Property Name or Floor columns in the second screenshot are being referenced. Double check your ranges.

Hammermill21

OK now they are, but still it bring back nothing.

Here it is linked:

And here is shows nothing:

I don't even get an error.

Paul Newcome

What are each of your ranges covering?

Hammermill21

{DATA || Gables Alternative Classroom Range 4} is the Capacity-Space Planning Number I am trying to bring in.

{DATA || Gables Alternative Classroom Range 2} is the Property Name I am trying to match

{DATA || Gables Alternative Classroom Range 3} is the Space number I am trying to match

Paul Newcome

Double click into each of the 4 cells as if you are going to edit them and take a look at what exactly is in them. Make sure they are an exact match.

How is the data on each sheet being populated?