Using Index-Match to pull non-unique values

Hi All,

I just joined the forum to hopefully get a solution to an issue I'm having. Unfortunately, I cannot share the actual data because its confidential, but I'll try my best to explain it while maintaining confidentiality.

Essentially, I have main tab that has a list of entries based on the activity of lots of different entities. Each entity, in turn, has its own worksheet. I'm trying to pull the row of data if the entity name appears.

Now the issue is, each each of these entities has several different sub-entities that make it up.

My formula currently is only pulling unique sub-entities. In other words, it is only pulling the first occurrence of these different sub-entities. Is there a way I can code this so that it pulls non-unique names(sub-entities)?

Here is the formula that I have on each :
=IFERROR(INDEX(Main!B$1:B$1260,MATCH(0,COUNTIF($B$1:B1,Main!$B$1:$B$1260)+(Main!$C$1:$C$1260>$L$1)+(Main!$C$1:$C$1260<$L$1),0)),"")

If you have any questions regarding the formula, I'd be glad to clarify.
- $L$1 is the name of the entity it is searching for on the main page.

Thanks for taking a look.