I have a constantly changing data set and want to use the range in formulas.
For example, one week I will use sheet2!J4:J20, the next week would be
J4:J50, then J4:J10, etc.

The beginning cell is always the same and I can find the last cell using a
counta function on the list.

I have tried the address function and can get the cell returned, but cannot
figure out how to use the information in another function, such as vlookup,
sum, etc.

HELP!!!