I
Inov8desin
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!!!
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!!!