P
patbarb
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 spreadshee
A
Dog ="="&Vlookup(A1,lookup_table,2
lookup_tabl
A
Dog C1&D
Log D
Bog Q
The result of this Vlookup is the text value =C1&D1, rather than the actual concatenated values of cells C1 and D1.
Thanks
patric
main spreadshee
A
Dog ="="&Vlookup(A1,lookup_table,2
lookup_tabl
A
Dog C1&D
Log D
Bog Q
The result of this Vlookup is the text value =C1&D1, rather than the actual concatenated values of cells C1 and D1.
Thanks
patric