Forum Discussion
Excel formula fill range formula with dynamic result
A1 has formula ={"dog","cat"}, which filled B1 with "cat". In A3 the formula is =CHOOSE({1,2},A1,B1), and it worked. My goal is to fill multiple cells with one cell and need dynamic result....
At the risk of muddling up your cats and dogs
= IF({0,1},"dog","cat")is also a standard solution. Of course. if you are up for a bit of excitement, you could always try
= LET(
select, RANDARRAY(1,2,0,1,1),
IF(select, "dog","cat"))
