Passing Cell Address to Offset
The following function returns the cell address I want to use in an offset
function:
=ADDRESS(MATCH(C$8,C$10:C$28,0)+8,D$1,4)
however, if I imbed this function in the first argument of the offset
function i.e.
OFFSET(ADDRESS(MATCH(C$8,C$10:C$28,0)+8,D$1,4),-9,0,1,1)
I get "The formula you typed contains an error." Any suggestions?
|