How do I use the cross reference in a cell rather than the value this enters?

Do you actually need =A10 in D10 or can you just put the cell reference in there?

Try this one

G20

Please Login or Register  to view this content.

Thanks for replying.

I'm not sure I may be clear enough. Perhaps the actual info I am using will make things clear.

I have several sheets, the initial one being my raw data. In another I wish to do collations of the raw data in a different order to that in the raw data, and then various predictions based on this.

So I pick up the necessary date in D10, by entering ='Raw Data'!A1654. I then wish to pick up other data relating to this date, but often offset in columns and rows, cascading across and down. So I wish to do something like:

G20= the data relating to D10's date, shifted along so many columns and up or down so many rows.

I can manually enter, say, one column as =OFFSET('Raw Data'!$A$1654,$G$22,$H$19) [where the number in G22 and H19 are the fixed offsets, which subsequently I can change to see what matters when a do a wholesale shift].

But what I hoping to do was instead of having to keep entering the 'Raw Data'!$A$1654 reference for each date, I'd like to pick this up from the first time I enter in in the D column.