The development version of Gnumeric now has a COLUMNNUMBER function such that COLUMNNUMBER("E")=5 and COLUMNNUMBER("AA")=27. (Anything involving INDIRECT is frowned upon due to its expensive dependency tracking nature.) Morten