Problems with auto numbering a column downwards

Dear all,

I would like to 'auto number' a column downwards.

It concerns the part B$1:B$2106;0), it should change to C, D and so forth when I 'drag down' the formula in the column.


=INDIRECT(ADRES(VERGELIJKEN($A$2;'Input Analytics'!B$1:B$106;0)+B$6;VERGELIJKEN($A8;'Input Analytics'!$A$1:$AA$1;0);;;$B$5))

Anyone any idea?

PS I am using the Dutch version of Excel so I suppose 'VERGELIJKEN' is 'COMPARE'

Hi B. Johnson,

Almost but not quite yet. Maybe you could have a look at the example attached?

Idea is that in the output sheets (Eng, NL) information is sourced from:
1) Input Adsense; and
2: Input Analytics

The output depends on the cell A1 (input Adsense) or A2 (input Analytics).
As these names / codes may be in a different row per each week. These need to be 'read' accordingly. With the formula I mentioned earlier it does not change the 'lookup' column for each week.

If you take cell B8 in Sheet 'Eng' as example it is correct (sourced from B). I have edited cell B9 manually (it is sourced from column C) it is correct as well. However I would love to 'auto number'/dragdown the cells. As I need to perform this action for 15 sheets in total and 52 weeks

Hope you can help!

Regards,
Robbert

Hello Rudi,

Thanks for your reply. However I believe I am looking for another solution. For the more elaborate question, please see example below in the thread.

Hi B. Johnson,

Thanks for the effort! However the formula does not yet provide the outcome as it should.
I have added some additional data in the 'Input Analytics' and 'Input Adsense' sheets that should be reflected in the 'Eng' output sheet.
In the output sheet cell
B10 - should show cell D4 of 'Analytics' namely D2 + 2
C10 - should show cell E22 of 'Analytics' namely E20 + 2
Each week is one column to the right. The row might differ, hence the check with $A$2 of the output sheet

In the output cell. for the 'Adsense' part.
F10 should show cell E10, namely F9 minus -1 column and +1 row
F110 should show cell G17, namely H16 minus -1 column and + 1 row.

Dankjewel voor deze input. Dit was reeds opgemerkt / meegenomen in een andere reactie. Helaas was daar mijn probleem nog niet mee opgelost.

I have added some additional data in the 'Input Analytics' and 'Input Adsense' sheets that should be reflected in the 'Eng' output sheet.
In the output sheet cell
B10 - should show cell D4 of 'Analytics' namely D2 + 2
C10 - should show cell E22 of 'Analytics' namely E20 + 2
Each week is one column to the right. The row might differ, hence the check with $A$2 of the output sheet

In the output cell. for the 'Adsense' part.
F10 should show cell E10, namely F9 minus -1 column and +1 row
F110 should show cell G17, namely H16 minus -1 column and + 1 row.