GOOGLE SHEETS: How to find and return the nth non blank bell value based on today's date column

[songo]

Hi All,
I have tricky question, want to combine HLOOKUP with Array & Index, functions.
What I am trying to accomplish, I have sheet that’s needs to be updated every day automatically, on the top of the sheet I have =today() function.
Now I have second sheet, it’s actually scheduler with team stuff, dates and planned additional activities in hours.
And here is the trick… not all people have such a activities, some of them don’t and cell in blank.
I want excel to find today’s column in scheduler (obviously HLOOKUP – but instead of putting index (row number) I want excel to pick up nth non blank value.
Below is link to table of scheduler example,
today - =today() is 26^th I want excel to show number 2.
Tomorrow- =today() will be 27^th I want excel to show number 3.

https://drive.google.com/open?id=0ByJQKthhcDhuRTdfS3RmMjgtdUk


On the link below I have found formula to pickup nth blank value, but it stick to specific range I need that range to be changed based on today’s date column picked up by HLOOKUP or some other function.
https://www.extendoffice.com/documents/excel/3970-excel-find-nth-non-blank-cell.html

 

[songo]

Re: How to find and return the nth non blank bell value based on today's date column

have counted chikens before they hatched... using example above i am able only to pickup 1st non blank value in column.