return last row number - formula (non-vba) - unknown number of rows used

[smak]

I have a document with two tabs.
1. summary sheet
2. Tucson -
a. column with data = 'Tucson Epi Curve'!C:C
b. this column will changes its last filled in row each week


desire: on summary document cell N1, return row number of last row in a column that has had data....non-vba


Currently I know the following formula that is on summary sheet works,
a. but this returns the value in the last cell in columns C from the tuscon sheet
b. =LOOKUP(1,0/(NOT(ISBLANK('Tucson Epi Curve'!C:C))),'Tucson Epi Curve'!C:C)
c. returned value = 19,278

I want it to return the row number for that cell that contained 19,278....so 817 (assuming that is the row number this week)


what are better options/ways to do this ....there may a better way to pull the value and or row number

 

[Fluff]

How about

=LOOKUP(2,1/('Tucson Epi Curve'!C:C<>""),row('Tucson Epi Curve'!C:C))