Defined Name using Index Match Offset between Dates

[Deddiph]

Hello,
I wish to use Index Match function to:
- define values between dates
- automatically create defined names for each column A, B, and C

The sheet expands to the right as the data increases, so would Offset function be workable to achieve the results?
Please see the sheet enclosed.
Million thanks.

[oeldere]

The data is structured in columns instead of rows.

Are you willing to re-arange the data?

(this can be done with a macro).

See in sheet 1 the bleu cells.

See in sheet output in the orange cells.

After that it is easy to analyse the data with addional formulas and after that with a pivot table.

See the attached file.

(I saw a similar question earlier this week, but was not able to find that question on the forum today.)

[Deddiph]

Thank you for your assistance, Oeldere!
This is greatly appreciated.

[oeldere]

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.