i have some formulas with feeds to other sheets, e.g.
='J:\SHARED\New Ops MI\Pilot Team\jeff barton\[dec.xls]1st'!$K$8
what i need is to be able to make part of the look up address variable
my attempt was:
='J:\SHARED\New Ops MI\Pilot Team\"(value,B50)"\[dec.xls]1st'!$K$8
then cell B50 would read "Jeff Barton", to complete the formula
any of you experts know if this is possible ?
='J:\SHARED\New Ops MI\Pilot Team\jeff barton\[dec.xls]1st'!$K$8
what i need is to be able to make part of the look up address variable
my attempt was:
='J:\SHARED\New Ops MI\Pilot Team\"(value,B50)"\[dec.xls]1st'!$K$8
then cell B50 would read "Jeff Barton", to complete the formula
any of you experts know if this is possible ?