Geek Girl 007
Board Regular
- Joined
- Mar 12, 2022
- Messages
- 127
- Office Version
- 2021
- Platform
- Windows
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | MLIST | A | B | C | ||||||||||
2 | A | 1 | 4 | 7 | ||||||||||
3 | LIST 1 | LIST 2 | B | 2 | 5 | 8 | ||||||||
4 | B | 6 | C | 3 | 6 | 9 | ||||||||
5 | ||||||||||||||
6 | Validation formula | =INDIRECT("MLIST") | =INDIRECT("_"&B4) | Table Names | MLIST | _A | _B | _C | ||||||
Sheet1 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
B4 | List | =INDIRECT("MLIST") |
C4 | List | =INDIRECT("_"&B4) |
SORRY for the delay.One option is with tables:
Book1
A B C D E F G H I J K L 1 MLIST A B C 2 A 1 4 7 3 LIST 1 LIST 2 B 2 5 8 4 B 6 C 3 6 9 5 6 Validation formula =INDIRECT("MLIST") =INDIRECT("_"&B4) Table Names MLIST _A _B _C Sheet1
Cells with Data Validation Cell Allow Criteria B4 List =INDIRECT("MLIST") C4 List =INDIRECT("_"&B4)
The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.This is GREAT Thank you