Is there a way to store formulas as text in a Vlookup table and then retrieve and activate them? For example, below I do a lookup on "Dog" (A1), return the text C1&D1 from the table and slap an equal sign onto the front of it. This does not magically activate the text into a formula, unfortunately.

main spreadsheet
A B
Dog ="="&Vlookup(A1,lookup_table,2)


lookup_table
A B
Dog C1&D1
Log D1
Bog Q1

The result of this Vlookup is the text value =C1&D1, rather than the actual concatenated values of cells C1 and D1.

Thanks!
patrick



---
frmsrcurl: http://msgroups.net/microsoft.public...heet.functions