get the cell content in an array which is nth row below that cell

[encioman]

dear experts,

what formula can i use for an array like from a month calendar (boxes) in which I can have the list (type) of schedules within every dates of the month.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]activity A[/TD]
[TD]activity B[/TD]
[TD]activity C[/TD]
[TD]activity D[/TD]
[TD]activity E[/TD]
[/TR]
[TR]
[TD]activity V[/TD]
[TD]activity W[/TD]
[TD]activity X[/TD]
[TD]activity Y[/TD]
[TD]activity Z[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]activity M[/TD]
[TD]activity N[/TD]
[TD]activity O[/TD]
[TD]activity P[/TD]
[TD]activity Q[/TD]
[/TR]
</tbody>[/TABLE]

in which I want a list like this:

date 5 - activity E
date 5 - activity Z
date 10 - activity Q
date 6 - activity M

What formula within the array can I use to have the list type of schedule ?

Thank you in advance dear experts

 

[Chrisdontm]

It appears that you are wanting to use the OFFSET formula

 

[encioman]

It appears that you are wanting to use the OFFSET formula

Thank you sir, its my first time to see this OFFSET, would you send example how to use it?

 

[Chrisdontm]

It is a bit lengthy to detail the workings of this formula.
There is plenty on the web on how to use it.

But I will give you a quick overview.

It has 5-parts to it.
It defines a range and can reshape as you need it to.
It can give you an answer to just one cell if you like, which is what you are wanting.

The five parts are;
First you tell it where to start.
then you tell it how many rows to move from that position,
then you tell it how many columns over to move.
then from there you tell it the size of the range you want, starting with the height,
then following up with the width of the range.

Any one of these parts can contain a formula to describe it's location.

For example: for the part of how many rows, you could have it do a match to match what row a day of the month is in...your answer would be a number.
That would be the number of rows it would move down, etc...

 

[encioman]

It is a bit lengthy to detail the workings of this formula.
There is plenty on the web on how to use it.

But I will give you a quick overview.

It has 5-parts to it.
It defines a range and can reshape as you need it to.
It can give you an answer to just one cell if you like, which is what you are wanting.

The five parts are;
First you tell it where to start.
then you tell it how many rows to move from that position,
then you tell it how many columns over to move.
then from there you tell it the size of the range you want, starting with the height,
then following up with the width of the range.

Any one of these parts can contain a formula to describe it's location.

For example: for the part of how many rows, you could have it do a match to match what row a day of the month is in...your answer would be a number.
That would be the number of rows it would move down, etc...

here is what i want... to have the list below

 

[encioman]

cannot paste photo