Executing created formulas

  • Thread starter Thread starter Paul B
  • Start date Start date
P

Paul B

I have a long list of formulas that I need to apply to
several items in a column. To make things easier, I would
like to break up the formulas into smaller modules and
have each item in the column use VLOOKUP to reference the
formula that applies to it. However, addresses in the
formulas need to be adjusted according to the position of
item in the column. After I have created the formula with
the correct address references using a combination of
INDIRECT and VLOOKUP, I am left with the text that I need
to be run like a formula. The cell is already a formula,
but the result needs to be run as if were a formula. Is
there a way to do this so I can construct this formula and
then execute it? Thanks.
 
Hi Paul,

I'd say you really need to ask this in an EXCEL (rather than
Word) newsgroup :-)?
I have a long list of formulas that I need to apply to
several items in a column. To make things easier, I would
like to break up the formulas into smaller modules and
have each item in the column use VLOOKUP to reference the
formula that applies to it. However, addresses in the
formulas need to be adjusted according to the position of
item in the column. After I have created the formula with
the correct address references using a combination of
INDIRECT and VLOOKUP

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)
 
Back
Top