LookUp and CountRows

[Phineas]

I have Gallery1 that displays data from List1.

I need to add a Label to Gallery1 that displays related data from List2; The formula output needs to be a total of rows.

I'm doing a similar this here that returns the content in the item.
LookUp(PoCFTCWarrantyProjectList,ThisItem.ProjectName=ProjectName).ProjectTeamSize

I need something like the above that looks at List2 and counts the number of rows that a ProjectName that matches the content of the Gallery1.Label1 (ProjectName from List1).

Something like -

LookUp(ProjectList,ProjectName, CountRows(Gallery1.Label1.Text=ProjectName)

[JasonWS · Accepted solution]

I don't think you need a LookUp() for this. What I would do is just perform a CountRows() on a filtered List2:

CountRows(Filter(List2, ProjectName = ThisItem.ProjectName))