Vlookup values from variable lists and name boxes

[FunkyDragon]

Good evening! This is my first post here, and I'm kind of an Excel newbie, so please bear with me. Almost everything I've been able to figure out has come from reverse-engineering other sheets and tutorials online.

I got a pretty good hang of "static" VLOOKUP formulas, but I'm trying something new.

I have an indirect function that allows me to define one cell with a pulldown menu, that another cell references to another pulldown menu

Example: A1 has a pulldown menu with VLAN10 VLAN11 VLAN12, etc.
if i pull down VLAN 10, Cell A2 has a list of clients for that VLAN.

I learned this jazz from this website:
http://www.contextures.com/xlDataVal02.html

Now Cell A3 is what I'm having issues with: I want Cell A3 to display an cable number for the client i pull down in A2.

I have several lists that i have entered into the name box, VLAN10Client and VLAN10Cable, VLAN11Client and VLAN11Cable, etc.

If i set A1 to Vlan10 and A2 to "Client 1" and then If i manually enter =VLOOKUP(A3,VLAN10Client:VLAN10Cable,2,FALSE) I get my cable number "C-0001"

But! I need this cell to be able to dynamically update based on what VLAN i select in A1 and then what Client i select in A2.

Thoughts? Thanks!!!