shift range of values if criteria is matched

[XtremeMaC]

Hello,
I'm yet again taking a stab at new things that are challenging me at 2am in the morning

I have a range of constant $ values from L5 to L205. ($5, $10, $15, ... (just an example they're not in any increments, random values))
Data to be matched is on $B$3 (always end of month)
Date range is B5:B365(always end of month with increments of 1 month: 7/31/2020, 8/31/2020, etc..) thus unique.

if any date value in B5-B365 matches B3, I'd like matched row to start filling/spilling the L5-L205 in column G.

example: if $B19 matched $B$3, then G19 would start with $5, $10, $15, ... end at D219.

I'm using indirect and offset right now, but I'm unable to move the range properly.. I believe I can use a name range to offset, but can't quite figure that out right now either..
Looking for sharp minded people to save me from hours for tinkering on the web.

I'll take any help please

TIA!

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[XtremeMaC]

I know, but data is pretty much it.
if it'll help, sure let me edit.

[AliGW]

With respect, I don't ask to see sample workbooks for the hell of it.

[XtremeMaC]

indeed lol. Ok OP updated with attachment and references updated with that of the sample attached workbook. Thanks!

[AliGW]

OK - I'll have a shufty.

[AliGW]

In G5 copied down:

=IF(B5>=$B$3,INDEX($L$5:$L$196,COUNT(G$4:G4)+1),"")

[XtremeMaC]

you, are, amazing! Thanks!!

As usual, I overthink and go off base with more complicated solutions, whilst it's as easy as index & count...

Once again thanks a bunch!

[AliGW]

No, not really - just seasoned in these matters.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.