Forum Discussion
Rob Formula help
I need a formula to display a total on sheet1 from a varying cell in sheet2 I've created a timesheet & need to display their total hours worked for the two weeks. I get the week number from cell E1...
RobEurelle I believe you want to do something like this:
=INDIRECT(TEXTJOIN(,,"'C FORTUIN'!", "E",XMATCH(E1,'C FORTUIN'!D:D,0)+19))