Excel getting parameter from Sheet1 to complete formula in sheet2 - switch different parameter in sheet2 from sheet1

Hi folks,

this time i hope anybody can help me with this excel problem. I've 2 sheets. Sheet1 with 9 different parameter to
complete a formula in sheet2. The data are transfered to sheet2 and the formula in sheet2 getting the parameter
from sheet2 to complete. Now i like to switch in Sheet2 from which line i'm getting the parameter in sheet1.
There are 9 different lines with parameter.
Pls see the example attached.

Thanks in advance.
mandy

in the example the formula only getting A2 or A5 or A8 or A11 or A15 or A18 or A21 (samaccoutname)
normally i've a lot of formula more with more parameters to create shared mailboxes
example.xlsx
LVL 2
Mandy_Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
Hi,

if in Sheet2 A1 you have the line parameter you could use in B2

=INDIRECT("sheet1!$A$"&A1)

Regards
0
Mandy_Author Commented:
Thank you but not resolve my problem.  The parameter in sheet1 are changed by customer. For example he likes
to order 9 different Shared mailboxes and he's filling 9 different parameters lines in sheet1. Sheet2 is hidden for him.
Normally to create a shared Mailbox i've 7 lines with different formulas filled with customer parameter and other
parameter which are always the same.
Now i just want to change the complete customer parameter tree in sheet2 with one click :)
1.Customer Parameter Line 1  - Create shared mailbox then switch to Parameter given in line 2
2.Customer Parameter Line 2 - Create shared mailbox  then switch to Parameter given in line 3
..........
I can do it with nine times having the complete formulas with different parameters in sheet2
but i want only one time the formulas with parameter in sheet2 and switching only the parameter
Regards
0
Rgonzo1971Commented:
Like I said you can change the variable in Sheet!A1
exampleV1.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mandy_Author Commented:
wow! Thank you so much
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.