Nested lookup list in data validation lookup list in Excel Table

[mrusin]

Hi,
I have question about best practicies to use Table1 with lookup fields delivered from another table (Table2) - but lookup list values is depend on another field in this Table1.

This is a classical problem with nested lookup list of available values delivered from another table with values filtered on another field in this table.

Table1: T_OWNERS
​

• 
  [*=left]Fields:
  • 
    [*=left]OWNER_NAME

{OWNER_1,
OWNER_2,
OWNER_3,...}
​

Table2: T_DC (Data Center)
​

• 
  [*=left]Fields:
  • 
    [*=left]OWNER_NAME,
    [*=left]DC_NAME

​{OWNER_1, DC_NAME_1,
OWNER_1, DC_NAME_2,
OWNER_1, DC_NAME_3,
OWNER_2, DC_NAME_4,
OWNER_3, DC_NAME_5,
OWNER_3, DC_NAME_6,...}
​

• 
  [*=left]Field OWNER_NAME is lookup list = INDIRECT("T_OWNER[OWNER_NAME]"

​
Table3: T_SERVERS
​

• 
  [*=left]Fields:
  • 
    [*=left]SERVER_NAME, OWNER_NAME, DC_NAME

{SERVER_1, OWNER_1,
DC_NAME1,SERVER_2,
OWNER_1, DC_NAME1,…}
​

a) Field OWNER_NAME is lookup list = INDIRECT("T_OWNER[OWNER_NAME]")
b) Field DC_NAME is lookup list = INDIRECT("T_DC_[DC_NAME]")c) And the b) list of available values for field DC_NAME of Table 3 (T_SERVERS) should be delivered/filtered/based on OWNER_NAME field from T_SERVERS Table3

How to achieve this kind od functionality..?
​