getting vlookup to return a formula instead of a value

  • Thread starter Thread starter vince
  • Start date Start date
V

vince

I have a graph which compares several pieces of data to
one line representing historic sales for one day of the
week. The y value in my graph is =AUAsinceJan02.xls!
ySalesTuesdays2, where ySalesTuesdays2 is defined as an
offset function (volatile result). I am trying to make it
so I can change this line of my graph by just selecting
the day of the week from a drop down menu. I replaced the
Y value by a Vlookup function that looks up the value
from a drop down meny in an array containing the days of
the week and the corresponding offset formula (all
similar to the one above). The idea was that the Vlookup
function would return the correct formula, but instead it
returns the result of the cell (which is always #VALUE!
since it is a range). ANy way to get Vlookup to teturn a
formula rather than the result?
Thx
 
You would need VBA for this, there are plenty UDF out there but I know that
Laurent Longres
Morefunc has one function called FORMULATEXT that will return the formula as
a text string
it can be downloaded here

http://longre.free.fr/english/
 
Back
Top