Something like below?
=CHOOSE(COUNTIF($A$1:A2,A2),$D$2,$D$3,$D$4)
Assuming each set of Text1~Text6 will have distinct match. You will need to extend formula as needed.
4th set will need something like...
=CHOOSE(COUNTIF($A$1:A2,A2),$D$2,$D$3,$D$4,$D$5)
Or you can set it up with index# for list of matches and use something like...
=INDEX($F$2:$F$8,MATCH(COUNTIF($A$1:A2,A2),$E$2:$E$8,0))
See attached.