Hi Ron

This also works thank you.

But I am not too sure how the formula works - I don't understand what it is
telling Excel to do.

What does '10^99' mean? I presume this means go to the last value in that
column
but I don't understand why it works and before I use the formula it would be
nice to know if there are any limitations to its use.

Thanks
Dave
"Ron Coderre" wrote:

Try this:

With:
Your list in columns A:B on Sheet2
NO other items in A:B except for the list

Then....
In a cell on Sheet1:
=LOOKUP(10^99,Sheet2!B:B)
That formula returns the last numeric item from Col_B on Sheet2

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"DaveM" wrote:

Hi,

I have a 2 columns of data that is downloaded from an extrernal source. The
list varies in length. At the bottom of the entries in column B is a cell
that calculates the average of all the entries above. The cell to the left is
titled 'Total Average (xxx)' where xxx is the number of entries.

I need to link to the Total Average figure from another worksheet.

I have been using the Index, Match function elsewhere. But because xxx
varies this is not possible.

Can I somehow use the Left function with Index Match such that only Total
Average is the Matched variable? And if so how do I write the formula for
this?

Or can somebody suggest an alternative method?

Thanks

Dave