Find Position of Next Nonblank Cell in Range

Seems like this should be pretty easy, but I'm not having much luck! I am using MATCH to find the position of a specified value within the first column of a table. This column contains numeric values (formatted as General, typically in ascending order but could be in any order) but also with many blank cells interspersed. Having found the value I'm looking for (in the first column), I then want to do some additional lookups, in the other columns of the table, but only in the range that extends down to the next nonblank cell in the first column. For example, in the image below, if I search for the value of 7 (in the leftmost column), then I want to do further lookups within the blue-shaded range (other columns are blank in this example, but would actually contain data):

Screenshot.png

My problem is: How do I find the position of the next non-blank cell (in the leftmost column), so I know how to set the (blue-shaded) range for my subsequent lookups? I am using:

=MATCH(TRUE,OFFSET(TableCol1,FoundRow,0,ROWS(TableCol1)-FoundRow,1)>0,0)

where TableCol1 is $C$4:$C$33 and FoundRow is the looked-up position of 7 within this column (in this case, FoundRow = 6). But this gives me a #N/A error. This is driving me nuts because a similar formula "=MATCH(TRUE,[Specified range using OFFSET function]>0,0)" works fine in another spreadsheet I have. What am I doing wrong?

I know the OFFSET function by itself is working OK, because =SUM(OFFSET(TableCol1,FoundRow,0,ROWS(TableCol1)-FoundRow,1)) gives the correct result. So why won't MATCH(TRUE,[Range]>0,0) work for me? I've also tried MATCH(TRUE,[Range]<>"",0) and MATCH(FALSE,[Range]="",0) but they don't work, either. Help, please!!
Sample file is attached:
Test File (MATCH to Find Next Non-Empty Cell).xls

Hello
Amending your formula for the next non blank row, this gives the row:

Formula:

Please Login or Register  to view this content.

Hope this helps.
DBY

Thanks to you both!

zbor, I am kicking myself now that I see (in my spreadsheet where a similar formula works) that it was indeed entered as an array formula! Of course! Thanks for reminding me of what I should have realized!

DBY, I like your solution even better (I prefer to avoid array formulas where possible). I was hoping for a solution that would work even if the values were NOT in order, but in my current tables the values are in ascending order, so your solution will work.

Thanks for the Rep mark.

DBY