HELP! Refer to every 3rd Column on a different Sheet

[alimagator]

Hello. I've been digging around the internet for hours and can't seem to find a solution to my problem.

I have a document with two sheets, one a master sheet and the second is a tally sheet.

On the Tally sheet, I have a cell that is used to enter the date of the check being performed.

Screen shot 2013-04-24 at 11.15.32 AM.png

Im trying to set up the Master Sheet to simply refer to the dates entered in Tally sheet and create it as a formula that I can drag to simplify the reference process.

Screen shot 2013-04-24 at 11.15.51 AM.png

Currently on the Master, cell C1 refers to the Tally Sheet cell L1 to get the date. On the Master Sheet I then need cell D1 to refer to O1 on the other sheet- skipping every 3 columns. Thus E1=R1, F1=U1, etc.

I've been trying different explanations I've found for similar tasks using =OFFSET and =INDEX functions, but I can't seem to make them apply to my situation. Seems like it should be fairly simple but I can't make it happen. Any ideas?

[nemo74]

Hi there,

Give this a try by pasting it your master sheet C1 and drag right

Please Login or Register  to view this content.

[Pepe Le Mokko]

Nice pictures - Sample sheets are easier to work with

[alimagator]

Perfect! Thanks for the help!