I am trying to generate "Drop down list" using formula.

The path I am using is :

Data > Validation ---List ----Formula

It seems there is limitation on no. of characters, which could be
typed in this FORMULA field.

Can someone help me in generating the list using someother technic.

Thanks in advance for your replies.