Hi,

Was wondering if anyone had any thoughts on an alternative to CELL("contents",INDIRECT( ADDRESS(ROW()-1,COLUMN()))) or really just INDIRECT(ADDRESS(ROW()-1,COLUMN()))?


I'm need to use a header as a lookup value across several columns against several interconnected sheets and want to/need to use this mechanism in a named range, problem is of course mr. indirect's volatility, and that for named ranges I need it to be sheet agnostic.

thanks for help