Hi,

Try this

=LOOKUP(9999999,C3:C12)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Don Guillett" wrote in message
...
Try this where 99999 is larger than ANY number possible
=INDEX(E:E,MATCH(99999,E:E))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
Hi - I have a column of cells that is fixed length but the entries within
it are not fixed, some columns might have more or less entries than
another column. I want to find the bottom entry in the list, regardless
of what row that entry is in and return the value of that entry please?

eg, all columns have 12 cells, col A has 3 entries, col B has 1, col C
has 6 etc. The entries are NOT in value order and cannot be sorted but
each column is independant of the others, if that helps.

TIA
Chris