troubleshooting Question

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

Avatar of Mandy_
Mandy_ asked on
Microsoft ExcelVB ScriptPowershell
4 Comments1 Solution299 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros