I'm trying to substitute a static range in a function with a dynamic one, and I cannot seem to get it right.
Essentially, I have the following function in one of my cells:
I would love to be able to substitute the MATCH function ranges for an actual function as follows:
< to be substituted by the following which essentially gives me the same result, except it's not static >
ADDRESS(CELL("row",ServiceFeesHdrs)+1,CELL("col",ServiceFeesHdrs)) &":"& ADDRESS(CELL("row",ServiceFeesHdrs)+ROWS(ServiceFeesHdrs)-1,CELL("col",ServiceFeesHdrs))
The address function gives me precisely the same result as the static range address.
Any help would be greatly appreciated.