I have a the following in an excel cell:

=GETPC|SP?!NumTicks

I am trying to modify it so that cell C2 contains the value "SP?" and
it is substituted into the above formula. Something like

=GETPC|$C$2!NumTicks

That doesn't seem to work. Any ideas? Thanks.

Jim