View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
 
Posts: 150
Default 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.