A1 will be an incremented value from 1 to 3.
when A1=1, then C1 will be 1+1, D1 will be 1+2, E1 will be 1+3.
when A1=2, then C2 will be 2+1, D2 will be 2+2, E2 will be 2+3.
when A1=3, then C3 will be 3+1, D3 will be 3+2, E3 will be 3+3.
etc.....

i'm looking for a single formula that will "internally" increment A1
from 1 to 3, then display the results in an "output range" C1:E3. can
an array do this? the method i use now employs VBA:
(VERY simplified)
let A1=1 copy answers to C1:E1
let A1=2 copy answers to C2:E2
let A1=3 copy answers to C3:E3

any help or alt suggestions would be appreciated!