Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
three data validation tables related to each other
I want to be able to relate the tables to the one previous to it.
If 'James' is picked from CLIENTS, I would like only 'James Job 1' and 'James Job 2' to be shown from JOBS. If 'James Job 2 'is picked, then only 'James Job 2 Function 1' and 'James Job 2 Function 2' and 'James Job 2 Function 3' to be shown from FUNCTION. I have tried the INDIRECT function and made it work with 2 tables, but can not seem to make it work with 3 tables. eg: CLIENTS James Arthur JOBS James Job 1 James Job 2 Arthur Job 1 Arthur Job 2 FUNCTION James Job 1 Function 1 James Job 1 Function 2 James Job 1 Function 3 James Job 2 Function 1 James Job 2 Function 2 James Job 2 Function 3 Arthur Job 1 Function 1 Arthur Job 1 Function 2 Arthur Job 1 Function 3 Arthur Job 2 Function 1 Arthur Job 2 Function 2 Arthur Job 2 Function 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for data in a column bring all related items in other colum | New Users to Excel | |||
Help filtering date related data | Excel Worksheet Functions | |||
How do I update data in 3 related files in Excel? | Excel Discussion (Misc queries) | |||
ENTER DATA EXCELL SO RELATED DATA APPEARS | Excel Worksheet Functions | |||
drop down lists/validation tables | Excel Worksheet Functions |