Hi,
In sheet 2 I want a formula in cell F2 to reference to sheet 1 cell E6. This formula I should be able to autofill the whole colom of F in sheet 2 where the value for F3(sheet2) = E13. So there need to be a jump for 7 days always.
F2= 149
F3= 231
F4= 320
....
Anyone knows what formula to use?
Thx!
Voorbeeld.xlsx
Put in F2
Formula:
Please Login or Register to view this content.
Fill down
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I would solve this problem with an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
added two more possible ways of working
one using CSE (on sheet 2)
other using Weekday formula and filter (on sheet 1)
I would like to use the indirect version but keep getting error: #REF!
Sheet 1 is called: Invoicing Q is my worksheet. I tried to used the formule as:
=INDIRECT("Invoicing Q!E"&A2*7-1)
What do I do wrong?
Thx
do you have leading or ending spaces in your worksheetname (so the worksheetname don't match)?
The worksheetname matches. I tried to change the name and apparantely the space between the name is causing the problem. Any solluction for that besides changing the sheet name?
Maybe using underscore instead of space
cannot see why that would be causing the problem...can you post a sample file with the error?
@Kevin1986
See the link below, for the solution of your problem.
#2 by Teylyn
=INDIRECT("'Monthly Summary'!C"&X1)
http://www.excelforum.com/excel-gene...reference.html
Last edited by oeldere; 06-09-2014 at 02:14 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks