D
Dim
Hi
i need to pick up a text formula (in RC format without equal sign)
from lookup table based on set of different paramenters and apply it
to the datatable (about 50K rows) for specific columns using formula
within a cell without looping using VBA..
for example lookup table might look like that:
AAA then formula RC3+RC25*RC30
ABC then formula RC2/RC20*RC4
i tried to break the process on two steps using intermedia column with
lookup formula to bring text RC formula into dataset table and then in
calculated column convert it into formula so that Excel can recognize
and does calc ..But i can't find the way to convert without using VBA
and looping through the whole column (50K rows takes a tons of time to
do so)
in the code I can loop through the whole dataset one by one using
VLookUP, assing RC formula found in the lookup table to a variable :
strFormula=Vlookup(A1, LookupTable-Range, 2, false) and then
attach it to a each specific cell : Cell.formula= "=" & strFormula.
How i can achive it in the cell without a code ?
cheers
D.
i need to pick up a text formula (in RC format without equal sign)
from lookup table based on set of different paramenters and apply it
to the datatable (about 50K rows) for specific columns using formula
within a cell without looping using VBA..
for example lookup table might look like that:
AAA then formula RC3+RC25*RC30
ABC then formula RC2/RC20*RC4
i tried to break the process on two steps using intermedia column with
lookup formula to bring text RC formula into dataset table and then in
calculated column convert it into formula so that Excel can recognize
and does calc ..But i can't find the way to convert without using VBA
and looping through the whole column (50K rows takes a tons of time to
do so)
in the code I can loop through the whole dataset one by one using
VLookUP, assing RC formula found in the lookup table to a variable :
strFormula=Vlookup(A1, LookupTable-Range, 2, false) and then
attach it to a each specific cell : Cell.formula= "=" & strFormula.
How i can achive it in the cell without a code ?
cheers
D.