Multiple drop down lists in the same cell

[wolfschenck1954]

Is it possible to have IF statements in the cell that gets drop down lists?
My need is to identify which drop down list to use pending the value in another cell.
the case is as follows:
IF cell A:1 = TS then the TS list drops down in cell A2
IF cell A:1 = W then the W list drops down in cell A2
IF cell A:1 = C then the C list drops down in cell A2
??

 

[etaf]

you should be able to use data validation - LIST , with an IF statement

Dependent List on entry in another cell.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	TS												TS List	W List	C List
2	2				IF cell A:1 = TS then the TS list drops down in cell A2								1	A	1-A
3					IF cell A:1 = W then the W list drops down in cell A2								2	B	2-B
4					IF cell A:1 = C then the C list drops down in cell A2								3	C	3-C
5
6
7
Sheet2

Cells with Data Validation
Cell	Allow	Criteria
A2	List	=IF(A1="TS",M2:M4,IF(A1="W",N2:N4,O2:O4))

 

[FrankViewPoint]

Etaf. Thank you for posting the IF statement formula above. It was just what I was looking for. However, I would welcome guidance on how I can reproduce the procedure for subsequent row in a table, so, for each row I can enter a key word in the first column that will then initiate one of the chosen drop down lists in the second column (in the same row), given that I could be processing up to 10,000 rows on a single spreadsheet. I need to do this to allow me to create a "general ledger" spreadsheet, where each row can then be used to select the accounts to credit and debit, given that my spreadsheet processes three different interconnected sets of accounts. Hopefully, this message will get to you. Again, thank you.

 

[etaf]

given that I could be processing up to 10,000 rows on a single spreadsheet.

for each row I can enter a key word in the first column that will then initiate one of the chosen drop down lists in the second column (in the same row),

This is A2 dropdown and B2 result
For 10,000 rows
and you would manually change 10,000 rows??

you should be able to apply to all rows
=IF(A1="TS",$M$2:$M$4,IF(A1="W",$N$2:$N$4,$O$2:$O$4))
NOTE fix the list with the $ so they dont also change

Book7
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	TS	2											TS List	W List	C List
2	W	A			IF cell A:1 = TS then the TS list drops down in cell A2								1	A	1-A
3		1-A			IF cell A:1 = W then the W list drops down in cell A2								2	B	2-B
4	C	1-A			IF cell A:1 = C then the C list drops down in cell A2								3	C	3-C
Sheet2

Cells with Data Validation
Cell	Allow	Criteria
B1:B4	List	=IF(A1="TS",$M$2:$M$4,IF(A1="W",$N$2:$N$4,$O$2:$O$4))