On sheet Organizations is defined table tOrg (I entered field names (header row) and formatted columns. Then I defined Data Validations in column OrgType for some number of rows. Then I selected all headers plus rows where I defined Data Validation, and with selection active I selected from Insert menu Table. Checked "My data has header row" and clicked OK. A Table was defined and a menu pane Design was activated. At left of menu pane I set the name for Table (the default is something like Table1) to tOrg. You can see Table settings, when you select any cell in table and activate then Design menu.

With defined Table, you can use table syntax in formulas.
TableName refers to datarange of Table;
TableName[#All] refers to whole Table (headers + datarange);
TableName[#Headers] refers to header row of Table;
TableName[FieldName] refers to datarange of specific field/column of Table;
TableName[@FieldName] refers to field value on same row with cell you entered the formula;
etc.

So tOrg[Orgname] returns all entries from field Orgname of Table tOrg.

Edit. Differ tables (which you could create in all versions of Excel), and Tables, which were introduced in Excel2007.
Edit. The only downside is, that you can't use tables, when you want to share the workbook. But I avoid Excel sharing anyway whenever possible.