Adapted LOOKUP?

[ChrisStandards]

Good morning Gurus,

I have a table. Across the top (X-axis) it has the 365 days of the year and on the left (y-axis) it has a series of names. Each cell has a letter that is updated each day.

01 Jan | 02 Jan | 03 Jan
A
B
C

What I want to do is have a separate table with 7 columns that extrapolates the last seven days data from the year. It needs to display the entre column based on the date at the top.

I cant find a function that will do this.

Please can you help?

 

[Trevor_S]

A HLOOKUP should work.
On your existing sheet, create a named range (including date headings) called data_table. On the new sheet, cell A1 should be =INT(NOW()) with cells B1 onwards deducting one so you get seven days.
The formula in A2 would be:
=HLOOKUP(A$1,data_table,ROW(),FALSE)
Copy this across all seven columns and down as many rows as exist on the original sheet.