referencing cell lnking to another tab in Excel that skips 2 colum

  • Thread starter Thread starter RD
  • Start date Start date
R

RD

Hi,

I am trying to link every 3rd column in Tab C into Tab A. Is there an easy
way to do this via a formula - I have tried Indirect and column however not
having any luck.

Basically in Tab A on Cell A2:
<Column A> <Column B>
=Tab C!AB$91 =Tab C!AE$91 etc.
In above case, is there a formula that can help me automate the calculation
in Column C?

Thanks so much!
 
One way, use this in the startcell:
=OFFSET('Tab C'!AB$91,,COLUMNS($A:A)*2-2)
Above returns the same as: ='Tab C'!AB$91
(note that I assumed the source sheetname is: Tab C)
Just copy the startcell across to extract it exactly as desired
Success? wave it, hit YES below
 
Try this in column A
=INDIRECT("Tab2!R91C"&(28+(COLUMN()-1)*3),FALSE)
then drag across to columns B, C, D etc

If you start in a column other than A, adjust the 28 down 1 for every column
you move to the right.
best wishes
 
Back
Top