Hi everyone,
Have been struggling for a while to get a document correctly formatted but with no success. Would very much appreciate all the help you can give me.
Ref Data.
- 1 column "X" with the values: A, B, C, D, E, F
- 1 column "ABC" with some values
- 1 column "DEF" with some values
- 1 column "123" with some values
- 1 column "456" with some values
Sheet:
- "X" field on A2 as drop down list
- Drop down list field on A3 with ref data from "ABC" and "DEF"
- "X" field is also on A4 cell as a drop down list
- Drop down list field on A5 with ref data from "123" and "456"
Problem:
- In Cell A2 if the user chooses A, B or C the drop down list in A3 should only retrieve values from column "ABC" and if the user chooses D, E or F the drop down list in A3 should only retrieve values from column "DEF".
In A3 cell the field has to be populated depending on the option choosen in A2 cell.
- In Cell A3 if the user chooses A, B or C the drop down list in A4 should only retrieve values from column "123" and if the user chooses D, E or F the drop down list in A3 should only retrieve values from column "456".
In A3 cell the field has to be populated depending on the option choosen in A3 cell.
Have been trying with INDIRECT, VLOOKUP ando some other random hints found online but none matches my expectations and problem.
Can you guys give me a hand please?
Thank you in advance
Bookmarks