I have been searching through google for a couple of hours and I continue to find information I already know. I am trying to create a list of school names based on a list of school that I would hypothetically be disbursing money to. I am trying not to use a pivot table. Please help. I can provide more info/examples if needed.

I am already using a dynamically named range:

=offset('[Applications Report.xlsx]Applications Report'!A2,0,0,counta('[Applications Report.xlsx]Applications Report'!$A:$A),1)