I was grateful to Mike for his response to my query back in October and the
suggestion works fine. I have, however, been puzzled by the syntax ever
since.

Could somebody explain to me the "6.022*10^23" element? I'm presuming that
the '*' and '^' are wildcards of some sort but haven't been able to work it
out!

Many thanks.


"Mike H" wrote in message
...
Hi,

To get the last value in a row use this which is for row 2. The formula
can
be dragged down for subsequent rows.

=INDEX(2:2,MATCH(6.022*10^23,2:2))

Mike

"Terry Bennett" wrote:

I know that there will be a simple solution to this but have been playing
with it for 1/2 hour now and not making progress!

I have a table of data (say A1:Z100). An extra column is added each week
when various figures are received. Hence, at the moment, I have a list
of
branches in column A and dates across the top in Row 1.

All I need to do is to populate a summary with data extracted from the
most
recent figures. I can do this easily with VLOOKUP but how do I programme
it
such that Col_index_num returns data from the column with the most recent
date in Row 1? I have tried using MAX but can't seem to find the right
syntax.

Many thanks.