Dependent Drop Down List

[lasc]

Is it possible to write a program that says?: If A1=A, then "Text", however if A1=B, then Drop Down List, otherwise nothing.

Example: =If(A1="Standard","48x72",if(A1="Options",Drop Down List,"")

I looked it up on Google and saw multiple explanations of how to make 2 different drop down lists dependent on data in another cell. But that's not what I'm trying to accomplish. I need the result to be text if one condition is met or a drop down list if another condition is met.

[bebo021999]

With formula, both text "48x72" and a Drop down list return is impossible.
With code, it is possible.

[lasc]

I have a good deal of knowledge and experience with formulas, but I know absolutely nothing about coding.

[Sybon]

If you use G-Sheet, you can do the dependent dropdown by the Filter function.
And for Excel you can use "=OFFSET($D$1,MATCH($G$2,$C$2:$C$12,0),0,COUNTIF($C$2:$C$12,$G$2))"