How do I reference a range of cells depending on another cell valu

B

batkinson

What I am trying to do is write a formula that can be used on a number of my
spreadsheets and will manipulate a range of data. However the length of this
range of data varies from sheet to sheet so I want to be able to plug a value
into a reference cell that will modify the range that this formula is
referencing. Is this possibile and if so how do I do it?

An alternative route that might suffice would be something like the offset
function IF I could modify the degree of offset based on a value plugged into
a reference cell.

Many thanks for your help, this is definately slowing me down!
 
Top