OFFSET return value if MATCH is true?

[kastsnow]

Hello all... I have a Lab scheduler I want to automate on the click on a button or dropdown.

I want to have a daily, weekly, monthly report.

I am currently working on the first problem. the Daily

I have a column that has Day 1 though Day 7

I have an offset indexed to match a string ="TRUE" or "FALSE" using this equation.

=OFFSET(INDEX(Calendar!G1:G365,MATCH("TRUE",Calendar!G1:G365,0)),0,-2,1,1)

Now if the current day is a Monday = Day 1, Tuesday = Day 2, Wednesday = Day 3 etc.

Now on Day 1 my lab schedule has updates and back-ups it performs. So if today is monday then it would populate the Monday's schedule.

if you have any questions I will try to answer them best I can

 

[kastsnow]

whats wrong with formula

=IF(MATCH(F7,Calendar!L1:R1,0),OFFSET(Calendar!L1,,,Calendar!L2:L25,),"NFG")

 

[Snakehips]

Apologies if it just me but I am struggling to put your question into context.
Are you able to clarify?