To have this formula work with numbers & Text ='T(INDIRECT("'"&
In article .com,
"Fin Fang Foom" wrote:
Domenic,
Did the formula you provied work for you? I could not get it to work.
No, it doesn't work. I merely mentioned that I tried the LOOKUP formula
and that it too didn't work. It looks like both LOOKUP and INDEX don't
want to accept the new array defined as Col_A.
|