using dropdown and formula in a cell

[Masa1989]

Hi i have 2 columns of data A and B

A contains some code or some model names depending on the output of the formula
TA00123
TA00131
TYA1231
Chipset
Processor
Alternator
etc

I want to use the dropdown in adjacent cell of B column, saying IF(LEFT(B66,2)<>"TA",$DB$6:$DB$10,CONCATENATE(MID(B66,15,2)," ","YM"))
Basically saying if the value of cell A contains TA letter , than i want to use the formula else give the dropdown list, i am trying this and i am getting error in dropdown saying the list should be delimited...is it possible??

Thanks in advance

[FDibbins]

i want to use the formula else give the dropdown list, i am trying this and i am getting error in dropdown saying the list should be delimited...is it possible??

no, sorry, it's not. You can either have data in a cell (typed in or from a drop-down) or a formula, you cant have both If you put a formula into the cell that has teh DD, the very 1st time the DD is used, it's selection will replace the formula

What exactly does your data look like?

[Masa1989]

hey ohh what is the other alternative?
i want dropdown to appear in one column only when coother column has Codes starting from TA , else use formula?

i have attached sample sheet for reference

[FDibbins]

OK so to make sure I understand you...

If E4 contains data that data from column B, then F4 takes some part of that text.
If E4 contains nothing(?), then you want F4 to have a DropDown instead?

If that is what you want, that cannot be done, for the reasons I explained above.

If that is not what you wanted, then please try and explain again

[Masa1989]

E4 wil always have either article code or model name, it ll not be blank, if it has code strting TA, i want that formula else the dropdown