Data Validation - without Create from Selection

[ionelz]

I do not want to Create from Selection because I have a simple selection
So I need a Formula in B1

A1 can be 1,2,3 so here I have Data Validation, List 1,2,3

I want in B1

B1="Text1","Text2" if A1 is 1 and "Text1" if A1 is 2 OR 3
If A1 is 1 I need to be able to have ...List text1,Text2

[ionelz]

=ifs(a1=1,"text1"&"text2",and(a1=2,a1=3),"text1")

...doesn't work for me...

[Hesamexcel]

Hi,
Does this formula work?

Please Login or Register  to view this content.

[ionelz]

no, it doesnt

[Pete_UK]

Try this in B1:

=if(a1=1,"text1"&"text2",IF(OR(a1=2,a1=3),"text1",""))

An alternative:

=IF(A1="","","text1"&IF(A1=1,"text2",""))

Hope this helps.

Pete

[protonLeah]

Are you trying to use the text in A1 as a data validation list in B1?

[ionelz]

but were to put this formula ?
If I SELECT 1 in A1 then I need to be able to SELECT or TEXT1 or TEXT2 in B1
Again, in A1 is Data Validation, List : 1,2,3
In A1 I have 3 options
If A1 selection is 1
I need to selctions in B1, List text1,Text2
so it is drop down list
A1 : 1,2,3
B1 : if A1 =1 then drop down list Text1,Text2
B1 : if A1 = 2 or 3 drop down list Text1

[GeoffW283]

I arbitrarily chose B4 to hold "Text1" and B5 to hold "Text2"

Select cell B1 then "Data validation", choose "List". Then under "Source" enter:
=IF(A1=1, B4:B5, B4)
Select OK to exit the data validation dialog.
That should do it:
If A1 is 1 then the dropdown list for B1 is:
Text1
Text2
If A1 is 2 or 3 (or anything else) then the dropdown list for B1 is:
Text1

I think that's what you were looking for. See the attached spreadsheet