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

Posted on 2014-08-27
Last Modified: 2014-08-27
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.

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
Question by:Mandy_
    LVL 47

    Expert Comment


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


    LVL 2

    Author Comment

    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
    LVL 47

    Accepted Solution

    Like I said you can change the variable in Sheet!A1
    LVL 2

    Author Closing Comment

    wow! Thank you so much

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    Synchronize a new Active Directory domain with an existing Office 365 tenant
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now