I need some help understanding why I cannot dynamically call a named range using a formula. I’ve attached an example spreadsheet as an example.

Inside the spreadsheet, I have a master table that is a named range. (Master_Table) Inside the master range are sub-ranges. (CLT3_Table and FLL2_Table) Depending on what sub-range is chosen from the dropdown, I would like to be able to lookup specific values within the range.

The challenge that I’m having is being able to dynamically call the site-specific named range through using either vlookup or (Index/Match). In the attached spreadsheet, what I need help with is the line labeled with a RED #5. This formula (Cell c26) needs to be able to pull the alias based on the site and port that are chosen using the (2) dropdowns. I can’t for the life of me figure out what I’m doing wrong and could really use some assistance. Thanks.
ExampleA.xlsx