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