using INDIRECT(ADDRESS(...))
Perhaps that's the appropriate way to write it with a desired result.
--
regards
"Dave F" wrote:
=ADDRESS(8,MATCH(AO5,Z5:AK5,0)+25)) returns AK8.
=T8-ADDRESS(8,MATCH(AO5,Z5:AK5,0)+25)) returns #VALUE!
=T8-INDIRECT(ADDRESS(8,MATCH(AO5,Z5:AK5,0)+25))) returns the
appropriate calculation.
Why?
|