Need to add iftext in relative cell refrence to a offset(match+match) formula

Training Stats, upload.xlsm

In this sheet I have a drop down menu for the week and another one for the day. Based off of that, I have these two formulas,

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

The second formula is abbreviated since it is so long. These formulas have the istext qualifier so that if the cell above it is blank it too will be blank.

With Week 1 and Day 1 selected in the dropdown menus of the Calculator sheet, you can see the data in O28:R33. Then looking at the Training Plan sheet that data is Week 1, day 1 and day 2. What I would like is a formula that before it pulls the data out of a row, it checks the A column of the same row for text, if there is no text, pull the data out of the row. If there is text, leave the cell blank.

The point of this is because right now each day contains 3 rows. However in the future I may want to vary that. Once the formula returns a blank, the istext qualifier already in the formulas would make all the below formulas return a blank value. The formulas in O28 and R28 do not need these qualifiers because there would always be at least one row of data to return.

Edit:My title says it has to be an iftext, if ifblank works better then that would be fine.

I would change the training plan sheet to make it easier to extract the data of interest:


Training Stats, changed for upload.xlsm