July 11, 2017
Every week I have to update 6 worksheets with the previous weeks results (Have attached copy of 1, others are the same format) then I adjust the formula in columns W to Z (row 4) and drag down.
I thought I would try HLOOKUP formulas to do this automatically each week on all 6 worksheets when I change the week numbers in cells V2 to Z2, however, it works fine on the first row (row 3) which relates to site 1, but when you drag down the 'Row_Index_Num' stays as '2'.
How can I change the formula so it pick up the correct row for each site?
Any help would be greatly appreciated
December 7, 2016
A simple solution is to use ROW formula to get the row number.
Your formula in cell W3 is currently:
My proposal is that you replace the 2 with ROW()-1 as row reference. With this you get 2 as row reference in cell W3, you get 3 in cell W4 and so on.
I would also remove the first $ symbol for the cell lookup reference, so I can copy the formula horizontally also.
Most Users Ever Online: 57
Currently Online: lebenya monaheng
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas