Link to data that's somewhere in the same worksheet

[SandsB]

Cell A1 in my file in the name of a workgroup. Cell B1 needs to link to data that's somewhere in column C between rows 10 and 50 for that workgroup.
In rows 10 through maybe 50, Column A is a workgroup name and Column C is a numeric value. My problem is each day some workgroups have no data so the cell I'm trying to pull data from is either in a different row every day or not there at all. If it's not there, I need to report 0.

So if my workgroup name (A1) is Projects and row 13 has A13=Projects and C13 = 12, I want B1 to show 12.
If the next day, Projects is in row 22 I'd want B1 to be populated with whatever is in C22.
If the next day, no row between 10 and 50 has Projects in column A, then B1 should be 0.

 

[Fluff]

How about
=IFERROR(INDEX(C10:C50,MATCH(A1,A10:A50,0)),0)

 

[SandsB]

How about
=IFERROR(INDEX(C10:C50,MATCH(A1,A10:A50,0)),0)

How about - this is perfect. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback