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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP source values are a formula result. Getting #N/A 7
Dynamic col_index_num in VLOOKUP? 5
vlookup returns formula instead of value 5
nested IF(OR Vlookup returning zero instead of value in target cel 7
ISNA Formula returning "False" instead of value 4
Vlookup and return sheet name also 2
VLOOKUP returning formula 3
Can VLOOKUP return a formula?? 2

Back
Top