Can I use vlookup to choose what forumula to use in a cell?

macropod · #5 11-02-2015, 12:41 PM

Quote:

Originally Posted by djrobst

basically need to lookup a text value cell which features at the end of my data and then return a formula from another sheet to go in the box that is completing the lookup.

so i have a sheet with column A having the name of the dataset, then row B, C, D etc would be the formulas I want the lookup to return when column A is matched.

If your formula is stored as a string minus the leading '=', rather than as an actual formula, you could convert it to an actual formula via your VLOOKUP using the INDIRECT function.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Would like to return a row rather than a cell using VLookup	canajun	Excel	7	12-10-2014 01:03 PM
VLOOKUP looking at another cell for its range	Rich18144	Excel	1	06-24-2014 07:56 AM
trying to use vlookup to calculate several different situations in one cell	heastlund	Excel	3	11-21-2013 12:38 PM
Choose your footer?	KenZu	Word	9	03-08-2012 01:40 AM
need help with a forumula	bigbosky32	Excel	1	11-07-2008 03:15 PM