Nick,
I cannot fully understand what you are looking for, but it seems to me
you need the OFFSET()function. Use the expression as the 3rd argument.
If your problem went down columns instead of across rows you could have
also used INDIRECT().

HTH
Kostis Vezerides