Numbers Fill between the dates right amount weekly or monthly

Question

JohnyyBrov Author

Level 1

5 points

Numbers Fill between the dates right amount weekly or monthly

Hi Guys

Im Looking for some help

Im trying to make a formula Where from Table 1 between the dates from column B to C

Will automatically fill up amount ( from Table 1 column E ) to the Table 2 , 3 between those dates

I would to have a option fill up weekly or monthly

Any advice please ?

That's my formula but seems like I do something wrong because doesn't show up anything in Table 2,3

IFERROR(

INDEX(Table 1::E, MATCH(TRUE,

(A2 ≥ Table 1::B2:B5) *

(A2 ≤ Table 1::C2:C5) *

(

(Table 1::D2:D5 = "Weekly") +

((Table 1::D2:D5 = "Monthly") * (A2 = Table 1::B2:B5))

),

0)

),

"")

Photo shows what's I mean

Greatfull for some advice

MacBook Air 15″, macOS 15.5

Posted on May 26, 2025 7:29 AM

Reply

Answer 1

SGIII

Level 8

37,532 points

May 26, 2025 9:15 AM in response to JohnyyBrov

Not a simple problem.

For the weekly schedule you can try something like this:

In B2:

= MAKEARRAY(ROWS(A2#),1,LAMBDA(i,j,Table 1::E4))

For a monthly schedule something like this:

In B2:

=MAKEARRAY(ROWS(A2#),1,LAMBDA(i,j,Table 1::E5))

Then perform an XLOOKUP on these individual schedules to insert in a full "calendar" table if needed.

SG

Reply

Answer 2

JohnyyBrov Author

Level 1

5 points

May 27, 2025 5:03 AM in response to SGIII

Hi

Im Grateful for your response but it's not exactly what I Wanted.

In table one where there are dates "from" and "to"

I Want to see the only the amount in table 2 and 3, From Table 1 column E

In specific dates that are listed in table one , they will be fill up weekly or monthly

Thanks

Reply

Answer 3

JohnyyBrov Author

Level 1

5 points

May 27, 2025 5:23 AM in response to JohnyyBrov

I try create another formula IF

=IF(AND(Table 2::A2 >= Table 1::B2, Table 2::A2 <= Table 1::C2), IF(Table 1::E2 = "Weekly", Table 1::D2 / 7, Table 1::D2 / 30),

IF(AND(Table 2::A2 >= Table 1::B3, Table 2::A2 <= Table 1::C3), IF(Table 1::E3 = "Weekly", Table 1::D3 / 7, Table 1::D3 / 30),

IF(AND(Table 2::A2 >= Table 1::B4, Table 2::A2 <= Table 1::C4), IF(Table 1::E4 = "Weekly", Table 1::D4 / 7, Table 1::D4 / 30),

IF(AND(Table 2::A2 >= Table 1::B5, Table 2::A2 <= Table 1::C5), IF(Table 1::E5 = "Weekly", Table 1::D5 / 7, Table 1::D5 / 30),

""))))

But seems still doing something wrong .. hmmmm. ?

Reply

Answer 4

SGIII

Level 8

37,532 points

May 27, 2025 7:31 AM in response to JohnyyBrov

JohnyyBrov wrote:

I Want to see the only the amount in table 2 and 3,

In Table 2 and Table 3 do an XLOOKUP on the intermediate tables generated in my example.

XLOOKUP - Apple Support

SG

Reply