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.