Hi guys,

Thread title probably does a poor job of what I'm trying to do.
I couldnt quite find something that would help me so far, I've been fiddling around with the INDIRECT function.

I have a document at x;

='http://***/Daily%20Operation/[*****%20Data.xls]Domestic Att'!$B$129 (** for privacy)

What I would like to do is have that figure 129, change depending on the number in a cell.
So for one set of data it would be 129, for another set it would be 130 and so on. But occasionally it will skip and go to 230.

So what I've been trying to do is combine text phrases with INDIRECT and a bit with ADDRESS but no luck so far. I think a lot of my issues are coming from prefixes and quotation marks.

I hope I've explained myself correctly.
Any help would be greatly appreciated.

Thanks,

Alex