Hello Guys,

I hope your all doing great!, Am lookin for some help in creating Random paragraphes in the same cell , I did a formula to generate random praragraphs but its not giving me a value . The idea is that we want to take cell from column 1 and we want to combine cell from column 2 and add the last column , Here is the formula and what am trying to do

=CHOOSE(250,CHOOSE(RANDBETWEEN(1,10),$A$2,$A$3,$A$4,$A$5,$A$6,$A$7,$A$8,$A$9,$A$10),CHOOSE(RANDBETWEEN(1,10),$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$B$8,$B$9,$B$10))

p1 | p2 | p3 | |

Yazan 1 | Younes 1 | Yazan and younes 1 | #VALUE! |

Yazan 2 | Younes 2 | Yazan and younes 2 | |

Yazan 3 | Younes 3 | Yazan and younes 3 | |

Yazan 4 | Younes 4 | Yazan and younes 4 | |

Yazan 5 | Younes 5 | Yazan and younes 5 | |

Yazan 6 | Younes 6 | Yazan and younes 6 | |

Yazan 7 | Younes 7 | Yazan and younes 7 | |

Yazan 8 | Younes 8 | Yazan and younes 8 | |

Yazan 9 | Younes 9 | Yazan and younes 9 |

By: Yazan