I have a workbook for my office bank account. It contains three sheets.

I would like to show the current balance on Sheet 1, i.e. the last item in column H, to another workbook called Payments (which is in a different folder).

I was given a formula =LOOKUP(1E100, Bank balance 2010-2011 $Sheet1$!H:H)

I really don't understand this, particularly what the 1E100 means. Can anyone help please?