Okay I'm wondering if it is possible to create this type of cell reference..
A2=5
In C2, D2, and E2 I want =Sheet2!C5, =Sheet2!D5, and =Sheet2!E5
Is there any way to do it so that it is =Sheet2!C[A2], =Sheet2!D[A2], and =Sheet2!E[A2]
I know that doesn't work, but I think you get what I am trying to do..