I dont know why I have this issue all the time. I need to keep track of inventory each week. Sheet one is the month overview, and the rest of the sheets are inventory taken that week. The totals taken each week are suppose to automatically correspond with the column on the month overview sheet with =IF(ISBLANK(B15)=TRUE,"",HLOOKUP(B15,'Taken 9-4'!$B$1:$AO$31,30,FALSE)) as the formula. But it never works when I go to create a new week. Can you help me set it up for the whole month? I know to change the B15,'Taken 9-4'!$B$1:$AO$31,30,FALSE to B15,'Taken 9-11'!$B$1:$AO$31,30,FALSE and so on.. but it doesn't work.
Solved by K. F. in 13 mins