I built a model that takes an input "A1" and produces 120 outputs "B1:B120".

How do I write a formula that says when A1=C1 export the array B1:B120, then
A1=C2 export the array B1:B120, etc...?

Thanks for your help.

John

hi
i'm about to crash. but formulas return values....they cannot perform
actions such as copy, paste, put values in other cells, EXPORT to somewhere,
call somebody's cell phone, ect. to EXPORT, you will need code. code can
return values AND perform actions.

regards
FSt1


"Emeryville John" wrote:

I built a model that takes an input "A1" and produces 120 outputs "B1:B120".

How do I write a formula that says when A1=C1 export the array B1:B120, then
A1=C2 export the array B1:B120, etc...?

Thanks for your help.

John