Because 9.99999999999999E+307 is the largest value you can get in a cell, so
if you look it up, you get the closest match, which for LOOKUP is the last.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Trevor Shuttleworth" wrote in message
...
Wow ! Why !??

Regards

Trevor


"Ken Wright" wrote in message
...
These will return the last numeric entry in Col D from the Sheets
listed.
Just
change the sheet references to match yours.

=LOOKUP(9.99999999999999E+307,Sheet1!D:D)
=LOOKUP(9.99999999999999E+307,Sheet2!D:D)
=LOOKUP(9.99999999999999E+307,Sheet3!D:D)
etc

Note, if you have spaces in your file names you will need to surround
the
reference with quotes, eg:-

=LOOKUP(9.99999999999999E+307,'Sheet 1'!D:D)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--



"Kevin Baker" wrote in message
om...
Hi everyone!

I have a workbook with several sheets, each with daily cash
collections from different vending machines in Column D. I would have
to have a totals page that would take the last collection from Column
D of each sheet. The last sheet would function like a summary page
showing the total collected for that day. As I enter a new collection
on the cash collection sheet, that value (since it is the last
collection) would be automatically put on the summary sheet.

Thanks
Kevin


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.605 / Virus Database: 385 - Release Date: 01/03/2004