Try this:
=LOOKUP(9.99999999999999+307,F:F)


" wrote:

I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.