Determining Last Non-Blank Cell in Column?

[The doomed]

I have a sheet set up as follows:

Cell I1 = Publication Date (Manually entered - always a Wednesday)

Col.A - Date - the Wednesday of each week for the foreseeable future
Col.F - Number of items
Col.G - Running total of the numbers entered in F
Col.H - Week number (incremental from 1)
Col.I - Average number to date

Col.I rows have the following formula (basically, if no figure in ColF show blank...
=IF(F7>=1,G7/H7,"")

Data entry starts on Row 3.

That all works fine in a nice simple way to give me what I want. However, I want to pull the latest average figure on to another sheet to present in a weekly report.

Can I use the publication date in I1 to determine what row to pull the average from? Or can I do something that will look to the last no-blank cell in Col.I?

Being honest - if there is something simple to look to the last non-blank cell in the colum that would be best going forward but I'm not fussed.
Any help greatly appreciated, as ever.

 

[dave3009]

I just tested this and it seems to do the job

=INDEX(A:I, MATCH(I1,A:A, 0),9)

9 refers to column so this is a simple count from left to right

If it's last used row you need then

=INDEX(A:I, MATCH(9.9E+255,A:A),9)

assuming the column is numerical change the 9.9E+255 to "zzz" if it's text

 

[Peter_SSs]

Try:

=LOOKUP(9.99999999999999E+307,I:I)

 

[The doomed]

Thanks to the both of you!

Rolled with the solutuion from Peter_SSs and works great.